views:

290

answers:

1

What's the best way to refresh a list box in MS Access? The way I have tried it doesn't seem to work :-/

This is my current method (onClick event of a button on the same form):

Me.orders.Requery

I have also tried

orders.Requery

and

Forms!currentOrders.orders.Requery

but none of them seem to refresh the list box's contents - I see no new items, even though I know that there are some. Closing off the form, and then re-opening it does show the new items, however.

+3  A: 

You could try and requery the form first and then requery the listbox

SwDevMan81
Thanks, that seems to have done the trick.
Joe Bloggs
That would seem to indicate that the listbox was showing data from the form you were editing, a detail that would have been helpful in your original question.
David-W-Fenton
Requerying the form isn't necessary so something is still wrong.
Tony Toews