View Full Version : Open Form in FormbyFilter Mode


BeccaJ
03-21-2001, 09:55 AM
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
03-21-2001, 01:26 PM
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.