creating keyboard shortcut for Filter by form

[talktime]

hi guys!!!

is there a way or work around to create a Filter by form keyboard shorcut. coz i use it alot, i want to accomplish filter by form and apply filter command directly from keyboard.

i use access 2003 and 2010.

 

[John Big Booty]

I believe the command you are looking for is;

DoCmd.RunCommand acCmdFilterByForm

You could try using the KeyPress event to detect your desired Key Board combination and fire the above mentioned command.

 

[talktime]

could you please explain full steps that how should i use this? i don't feel comfortable with VBA

 

[John Big Booty]

Perhaps this post will give you some pointers.