"Reset" combo boxes
Yes, use a command button and label it Clear Filter. Code the onclick event:
Me.mycombo.value = ""
Me.requery
--
Milton Purdy
ACCESS
State of Arkansas
"AccessKay" wrote:
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.
|