"Reset" combo boxes

[AccessKay]

I have an unbound form with combo boxes used as filters for my reports. How
can I reset the combo boxes back to blanks so the user doesn’t have to exit
the form to choose a different filter selection? Can you set up a command
button that resets them?

Thanks for any suggestions.

 

[golfinray]

Yes, use a command button and label it Clear Filter. Code the onclick event:
Me.mycombo.value = ""
Me.requery

 

[Douglas J. Steele]

Me!NameOfComboBox = Null

 

[AccessKay]

Thank you! This works great.

Yes, use a command button and label it Clear Filter. Code the onclick event:
Me.mycombo.value = ""
Me.requery

 

[AccessKay]

I tried this way too and it also works nicely. Thanks!