Open Form in "Filter by Form" mode

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've got a form that users will use to enter/search for data. I would like
the form to open in "Filter by Form" mode, so the user can immediately enter
their filter criteria.

How can I get the form to open in this mode?
 
Try:
RunCommand acCmdFilterByForm
either immediately after you OpenForm, or in the Open event of the form.
 
Works great - thanks.

Another question. I added the code you specified to the OpenForm event, and
I also have a message box that pops and says "Select filter criteria and
click Apply Filter button"

Can I control the location on screen of this message box? I would prefer
something towards the top, rather than in the center.
 
Back
Top