Filter by form

R

Rookie

If I use filter by form, to execute the filter/search, I need to click in the
"filter botton", how can I execute the filter by pressing ENTER...?
 
R

Rob Oldfield

You really don't want to have *every* return on a form trigger a filter by
form or you're going to annoy your users who have got used to using it for
other reasons... but pick a better event and use...

DoCmd.RunCommand acCmdFilterByForm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filters 0
Help creating a search form in Access XP 0
Sorting and filtering text 0
Filtering data from a non-continuous list 3
filter on dates 2
Filtering a form - wait 2
VBA office 365 on windows 10 0
If I use a filter on my form, will the recordsetclone reflect the filtered form or the unfiltered fo 2

Top