Problems with a query in a list box

[admaldo]

I am having problems with a list box that the row source is a query. The list box is not refreshing the query results. The query is changing every time it is executed but the list box displays the records extracted the first time it was populated. Can anyone help on this. Thanks.

[StepUP]

Requery the control:

Me![MyList].Requery

You could do this, for example, in the OnCurrent event for the form, or the OnGotFocus event for the control.