Applying Filter by Form through Command button

Question

Hi, I want to generate filter by form to accept user input from a command button rather than usingsort and filter of Home menu. similarly executing the filter after user input from command button rather than using Home Menu.

Answer 1

You can use

RunCommand acCmdFilterByForm

to display form filter, but once you do so, all command buttons are hidden, so you can't use a command button to apply the filter. That can only be done from a toolbar or from the ribbon.

Answer 2

You can create a macro named AutoKeys to assign keyboard shortcuts - see [url=http://office.microsoft.com/en-us/access-help/run-an-access-macro-by-using-a-keyboard-shortcut-HA010239111.aspx]Run an Access macro by using a keyboard shortcut[/url].

Answer 3

Hi, I got it. However i do not want to use Main Menu to activate filter by form and to execute query. What all options i have as after activating in runtime i cant apply filter. do we have shortcut keys as in Oracle F7 to enter query and F8 to execute query.******