Reset comboxbox so that paremeter query can be re-run with a new parameter.

[wehoscottward]

Hello. I have a comboxbox that runs a parameter query when the user clicks on the combobox. The combobox works great and generates a dropdown list of all records that matche's the query paremeter. Now I want the user to click on a command button that resets the combobox so that the user can enter another parameter.

Me.Combobox2.RowSource = ""
Me.Combobox2.Value = Null

Any help here would be appreciated. Many thanks.

 

[mrojas]

How about:
Me.Combobox2=""
This will clear the text area of drop-down

 

[wehoscottward]

Actually, what worked for me is:

Me.Combobox2.Value = Null
Me.Combobox2.Requery

Thanks.