How to "ApplyFilter" on form, without using Menu

[Paul Kirkaas]

Hi,

Better expressing my earlier question, how can I allow a
user to ApplyFilter in Filterbyform without requiring
him/her to use the menu? I would like to put a button on
the form, but when the I start "FilterByForm", all buttons
on the form become disabled. Is there a better way?

 

[Arvin Meyer]

Better expressing my earlier question, how can I allow a
user to ApplyFilter in Filterbyform without requiring
him/her to use the menu? I would like to put a button on
the form, but when the I start "FilterByForm", all buttons
on the form become disabled. Is there a better way?

Filter by form locks the form into an unbound search form. If you haven't
disabled it, you can right-click on the form and choose Filter By Form, and
right-click on the form again to choose to Remove it.
--
Microsoft MVPs have a question for *you*: Are you patched against the Worm?
http://www.microsoft.com/security/security_bulletins/ms03-026.asp

Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access