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 ?