View Single Post
  #2  
Old May 21st, 2010, 04:54 PM posted to microsoft.public.access.forms
Golfinray
external usenet poster
 
Posts: 1,597
Default "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.