Refreshing a listbox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bnmohan - 26 Jul 2008 10:36 GMT

Hi!

I have a listbox whose data source is an SQL Query : sele abcd from defg dist
When defg is updated with a new record, the new value of abcd does not appear
in the listbox when the listbox is called again, unless the form is killed
and reloaded.

I am sure there is something simple I am missing.

Any advice?

Mohan

Reply to this Message

Stefan Wuebbe - 26 Jul 2008 10:49 GMT

> Hi!
>
> I have a listbox whose data source is an SQL Query : sele abcd from defg dist
> When defg is updated with a new record, the new value of abcd does not appear
> in the listbox when the listbox is called again, unless the form is killed
> and reloaded.

Hi Mohan -

Assumed you are using RowSourceType=3, try yourListbox.Requery()

hth
-Stefan

Signature

|\_/| ------ ProLib - programmers liberty -----------------
(.. ) Our MVPs and MCPs make the Fox run....
- / See us at www.prolib.de or www.AFPages.de
-----------------------------------------------------------

Reply to this Message

bnmohan - 26 Jul 2008 13:25 GMT

Hi Stefan!

Very sad. I did not see that.

Thanks a great deal

Mohan

>> Hi!
>>
[quoted text clipped - 9 lines]
>hth
>-Stefan

Reply to this Message

Stefan Wuebbe - 26 Jul 2008 14:09 GMT

You're welcome.

-Stefan

> Hi Stefan!
>
[quoted text clipped - 17 lines]
>>hth
>>-Stefan

Reply to this Message