Apply Filter button - Can it ever be used?

[BadRabbit]

Having a bad day today. I have a form button that does "create form filter". I created a button then to "apply form filter", which is available from the button "wizard".

But seeing as choosing "create form filter" disables all buttons, how can I use the "apply form filter"?

Note the end user will not use menus, just buttons.

Thanks for any help.

 

[JeremyNYC]

Have you looked at the built-in filterj-by-form feature? Check into this in help. If this doesn't do what you need, come on back and let us know.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.

 

[BadRabbit]

Not sure... I've tried the ServerFilterByForm but it just gives "invalid reference" errors despite that I typed it in as help suggests.

I've tried the DoCmd function, which works, but disables all buttons (a command to re-enable the required button gives an error), so I can't retrieve the records without accessing the menu.

The menu and toolbars work, but because the customer won't be getting (and doesn't want) menus then this won't help me.

All I need is a way of enabling the execute filter button...