apply filter button on form

[Guest]

My users prefer that all functions be executed by using buttons directly on
the forms (i.e. no toolbar menus). On one form, I have a button that
executes filter by form (acCmdFilterByForm). No prob there, but it disables
any other buttons I may have on the form. This prevents me from using a
button that would then apply the filter criteria after it is entered. Any
suggestions?
I would love to hear a solution that involves a popup, if possible. Maybe a
form that pops up when the "filter by form" button is clicked that contains
brief instructions for the user and the "Apply Filter" button. I've tried
this but it doesn't work for me yet because it is a seperate form. Is there
a way to send a command to execute on a form that does not have the focus?

Thanks for anything.

 

[Ron Hinds]

To call routine on a form that doesn't have the focus, you need to make the
routine you wish to call Public. Then use this syntax:

Forms!your_form_name!your_routine_name