Displaying a Variable on a Report 1

[mdweezer]

Currently I have a form. From it I am passing values to a report to generate a SQL qry which I then execute using Me.Recordsource = Foo

Within the report code I am also putting together a string based on the criteria of the form i'm launching the report with. The variable is of type string and is called "list".

When I execute the report, how do I get this variable to display on the report?

Thanks.

 

[scriverb]

If you store the variable value in an invisible text control on the form calling the report you can make a direct reference to that control.

=FORMS![formname]![controlname]

Or change the variable to a database Global variable. Then create a function to retrieve this global variable.

Global vStrVar as String
Public Function StrVar as String
StrVar = vStrVar
End Function

Now make a call of the function to retrieve the string value:

=StrVar()

Post back if you have any questions.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[mdweezer]

I had gotten the same result from another forum and it worked perfectly.

Thanks