Refresh data on menu form

[bibbyd01]

Hi all

I'm a little stuck with a on a form

I have a menu form that has a drop down list, populated by a table, that stores a value to run in a query.

When the user selects the name in the list, they click a button to run the query/report.

I then want the list to go back to it's default value, which is blank. I thought I could do this simply by refreshing the menu form, but this causes an error and says that it can not be refreshed at this time. Is there anything else that I can try?

[TG_W]

At the end of your code that runs the query/report, add the code below:

Me.YourComboBoxNameHere = Null

[bibbyd01]

This actually did exactly what I asked, but I didn't include the rest of the details which has somewhat affected the outcome.

We have a split database due to network instability and I wanted the form the user is using to not access a table unless they were working on it. I noticed that even though the above procedure cleared the combobox field, it still had access to the table in the backend database.

I cured this problem by closing the form and reopening it when the user navigated back to the menu form. It has worked but probably wasn't the easiest solution.

Thanks for your help though.

[TG_W]

Based on the above, you could also just close and reopen the form and not worry about clearing the combo box. The user wouldn't have to navigate back to the form that way, and it would clear the selection and allow for more reports/queries to be run back-to-back.

Docmd.Close acForm, "YourFormName"
Docmd.OpenForm "YourFormName"