[AccessD] Requery ListBox doesn't work

Hi Jim

Then you probably need to requery the form after having saved the
record ...

/gustav



> Thanks for the suggestion.  Tried it - still doesn't work.
> However, it does requery and displace the previous change!
> I've used the requery on several forms and it usually works.  
> I just cannot figure out why on this form it doesn't!
> Thanks
> Jim

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock
> Sent: Monday, July 12, 2004 8:10 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Requery ListBox doesn't work


> Hi Jim

> I guess you need to save the record before asking for the requery.

> /gustav


>> Two identical lines of code to requery a ListBox, one works, one doesn't.
>> Both on the same form, both reference the same ListBox.
>>
>> The one that works is located on the on click event of a button to delete
>> the current record. Delete the record - requery the ListBox.  Works.
>>
>> The one that doesn't work is on the after update event of a text box.
>> Enter text - move to next text box - requery ListBox.  Doesn't work.