filter report via bound text box

[JeremyPSU]

I have a Report that has a bound text box in the report header.


Trying to filter the Report by the value set in the text box.

Text box: [Customer]
control source: =[Forms]![Customer Look-Up]![Customer]

Report: [Sales]
Field in Report trying to Filter: [Customer Name]



What would I set the filter as or is there a better way??

May be posted already but having hard time looking for it

[ConneXionLost]

Assuming you have a query as the source for the report, then you'll want to add:

=[Forms]![Customer Look-Up]![Customer]

as criteria in the query.

Cheers,

[JeremyPSU]

Don't know why I didn't make a separate query for this report.
I had one query linked to 2 different reports.

Made it a lot easier
thanks for the help