Refresh Listbox on a form

[ETID]

Hi All,

I have a form with sub forms...and a list box


when I select an item from the list box, the form shows the data associated with that selection.

There are criteria in the sub form that if edited will change the results of the query that the Listbox is based on.

I need a line of code to refresh the list box when edits are made.

I can do this manualy ... through the menu by making my edit in the subform, then selecting the listbox and then doing a refresh from the menu...but I would rather have it automated.

Thanks.

 

[gol4]

In the listboxes on enter event place this code

Me.Refresh