Open Form in FormbyFilter Mode (1 Viewer)

[BeccaJ]

I want to open a form and have it automatically come up on a filter by form page. I saw a previous post to put DoCmd.RunCommand acCmdFilterByForm in the OnLoad event of the form. I tried doing this, but I got an error message that it couldn't find the macro DoCmd.

Can anyone help me?

 

[llkhoutx]

You have to specify the filter, before you open a form utilizing that filter. Open a form in design view and place the filters you want on in. The have a button which opens your filtered form, with the recordsource being a query with the filters on the first form as the criteria for the various columns.