How to refresh listbox

Question

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.

Answer 1

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