Procedure stack

[Guest]

I have a report that will be opened with the DoCmd.Openreport command.
However the form in which this command is stated can have more then one
instances. The behavior of the report is depending on the calling form. How
can I let the report know which instance of the form called it?
E.g. opening a form one can use the OpenArgs property.

 

[SA]

Karl:

Use a SQL WHERE in the DoCmd.Open report call, rather than defined paramters
(e.g. Form!MyForm!MyControl) in the report's underlying query. That way,
you can use the Me!ControlName syntax for the parameters. e.g.
"[CustomerID] = " & Me!txtCustomerID.