Prev: Convert a form to a split form?
Next: Autoformats
From: AccessKay on 21 May 2010 11:30
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.

From: golfinray on 21 May 2010 11:54
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.
>
From: Douglas J. Steele on 21 May 2010 11:57
Me!NameOfComboBox = Null

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"AccessKay" <AccessKay(a)discussions.microsoft.com> wrote in message
news:A52D8F0C-6102-4848-9C23-B593CF29A132(a)microsoft.com...
>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.
>


From: AccessKay on 21 May 2010 14:22
Thank you! This works great.

"golfinray" wrote:

> 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.
> >
From: AccessKay on 21 May 2010 14:23
I tried this way too and it also works nicely. Thanks!

"Douglas J. Steele" wrote:

> Me!NameOfComboBox = Null
>
> --
> Doug Steele, Microsoft Access MVP
> http://www.AccessMVP.com/DJSteele
> (no e-mails, please!)
>
> "AccessKay" <AccessKay(a)discussions.microsoft.com> wrote in message
> news:A52D8F0C-6102-4848-9C23-B593CF29A132(a)microsoft.com...
> >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.
> >
>
>
> .
>
 | 
Pages: 1
Prev: Convert a form to a split form?
Next: Autoformats