By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,471 Members | 711 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,471 IT Pros & Developers. It's quick & easy.

Remove Filter

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"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
Nov 12 '05 #2

P: n/a
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.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.