Sending parameters to a report

[Guest]

I develop in Access 2003 and I've used the OpenArgs property to send
parameters to my report. It worked just the way I wanted. Now I realized that
the client uses Access 2000 and the .OpenArgs property doesn't exist. What
can I use instead?

 

[Wayne Morgan]

You can use the parameter as defined in the query directly in a report. For
example, if you have a parameter in a query called [Please type in a date],
you can use this in a calculated textbox in the report.

Example:
="Reporting for " & [Please type in a date]

Also, depending on where the parameter is coming from, you may be able to
have the report get it directly. For example, if you have a form for
inputting the parameters and you leave that form open for the query to read
the parameters from it (hidden is ok, just as long as it's open) then the
report can read those values from the form also.