Remove Filter

[DD]

I have a command button that applies a filter by customer name, i want
a Cmd Button to remove the filter, Access does not supply one can
anyone help.
Regards
DD

[Rick Brandt]

"DD" <da**********@bigpond.com.au> wrote in message
news:14**************************@posting.google.c om...

I have a command button that applies a filter by customer name, i want
a Cmd Button to remove the filter, Access does not supply one can
anyone help.
Regards
DD

Me.FilterOn = False
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Deano]

DD wrote:

I have a command button that applies a filter by customer name, i want
a Cmd Button to remove the filter, Access does not supply one can
anyone help.
Regards
DD

If I recall correctly is there not some sort of Toggle button you can employ
to achieve this kind of effect? I had a simply app years ago that allowed
the user to check several boxes and then hit a toggle which filtered some
data. The button remained down. You could then click it once more and the
filter would be removed. Check the Control toolbox, though I suppose this
might depend on the version of Access you use. It was there in Access 95
I'm pretty sure but I'm haven't checked to see if it is in Access 2000.