Problem including unrelated text in Report

[Ken]

I've created a report in Access 2000 based on a query and
it works fine. However, I'd like to include some text
strings such as 'strCompanyName' and 'strCompanyAddress'
in the report which are not included in the query. These
values are pulled from a table and saved as string
variables prior to the report being opened.

I thought it might be as simple as using the report's
Open event and saying something like 'me.control =
strCompanyName', but that doesn't seem to work. Any
suggestions? Thanks in advance.

Ken

 

[Larry Linson]

If you are using Access 2002 or 2003, you can use the OpenArgs parameter of
the DoCmd.OpenReport to pass text information. In earlier versions, you can
save the values as Public variables in a standard Module, or create
user-defined Functions in a standard Module that return the values you want.

Larry Linson
Microsoft Access MVP