Setting Variables for reports

[Dragnog]

Hello All,
I am wondering if it is possible to set a variable for a report as a condition for that report. To give you an example, if I had a report of all the staff at the company and wanted to search for one particular staff member, entering their name in a text box on a form, how would I be able to use that in the query for the report so that I only brought their name up?

Daniel

 

[KenHigg]

Use the text box as a parameter for the underlying report's query?

kh

 

[Dragnog]

Sorry I need you to be more specific. I am assuming that I need to put something into the criteria of the query in square brackets, creating something like a variable - how do you then associate this with the text box?

Do you just put in the text box:
=[variable_name]

Is that correct?

Daniel

 

[KenHigg]

Something like:


=forms!myForm!myTextBox


???
kh

 

[Rich]

You could of course also use the Where clause of the open report method