Updating the content of a listbox (MS Access2007)

[ODRAP]

On a form i have a listbox "lstArticles" who's recordsource is a query that shows all articles that are in stock. "Qty > 0"
if for some reason one of the articles who wasn,t in stock anymore is brought back in stock, the result of this must be reflected immediately in the listbox when the form will be opened again.
In the event "On load "of the form if have put the code : me!lstArticle.requery . However, i found out that this doesn't help. Sometimes i have to open the form more than ones before the content of the listbox is reflecting this change. What can I do to solve this problem ?

[HansV]

Is this related to <post:=748,097>post 748,097</post:> and following?

[ODRAP]

yes

Greetings

[HansV]

In the other thread you mentioned that the form doesn't get closed, only hidden. So the On Open and On Load events aren't appropriate here. Try the On Activate event of the form.

[ODRAP]

Hans thank you very much for the effort to help me !!!