I have an Access form with two listboxes. After the user selects a value from each and clicks on a submit button I save the values and want to refresh the listboxes. I call Listbox.Requery but it doesn't seem to work properly.

When the form displays nothing has changed. If I select a record from the listbox, then the records update. I need the change to happen on the click of the submit box.

Any suggestions???