Clearing Contents of a Dropdown

[tanyalee123]

Good afternoon!

I have a form, and at the top I added 2 dropdown fields to assist the user in searching. One to search by SSN and one to search by last name. Because these work independently of one another (i.e. when the SSN dropdown is used, it doesn't effect or change the search by last name drop down; it's just 2 options for her to search), I don't want it to look confusing for the user if she uses the boxes for 2 different searches.



Therefore, I'd like the contents of the search to empty once she clicks elsewhere (loses focus), and that way if her eyes move up to those 2 search boxes after the record has been found, they will be empty. I'm assuming I need to use VBA to do this...anyone know how? Thank you!!
Tanya

[June7]

Those two comboboxes are UNBOUND?

Are you using a dynamic parameterized query as the form RecordSource?

Do you have a procedure that requeries the form? Include code in that procedure to empty the comboboxes.

Me.comboboxname = Null

[tanyalee123]

Thank you for responding.

Yes they are unbound combo boxes (they were creating just by using the combo box wizard in which you indicate you want the combo box to find a record based on your choice). Sorry, I don't know what your second question means, but the wizard creates a query as the row sourse, yes.

Where would I put that procedure? In the properties under the "After Update" event, there is a macro..the Action is "SearchForRecord" and the arguments are - , , First, ="[UniqueID] = " & Str(Nz(Screen.ActiveControl,0)). This is all created by the wizard.

[June7]

My second question was regarding the form RecordSource, not the combobox RowSource. However, disregard it.

The code I show is VBA example. I think doing the equivalent in macro requires SetValue method. I never use macros.