Passing a string to subform's Filter property while opening main form

[April Marano]

I'm using Access 97 to create a form that a user can use to enter search
criteria. He will then click on a button (cmdOpenDatabase) thereby opening
another form whose underlying query is filtered using criteria derived from
the first form.

I understand that I can create an event handler for the cmdOpenDatabase
button that will create a WHERE string that I can use as one of the
DoCmd.OpenForm parameters. The problem is, I want to pass that string to
the Filter property of one of the soon-to-be-opened form's SUBforms (not the
main form).

How can this be done?

Much thanks in advance!

April

 

[Arvin Meyer]

Have a look at the Search Wizard on the Access Web:

http://www.mvps.org/access/modules/mdl0056.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access