Put Criteria in Report? 1

[BLutgen]

I have report which is based on a query. The query gets its criteria to run from two text boxes and a combo box on a form. Basically the combo box is a customer, and the text boxes are beginning date and end date. On my report, in the report header, I want the customer name and those dates to appear that were entered into the boxes on the form. That way, you can tell who and when the information is for. Do I use text boxes in the report header? Any help would be great.

Brad

 

[JoeMiller]

You can put the controls anywhere you would like, the report header is a good place though. Set the control sources of the report like this:

Company
=Forms!MyFormName!MyCompanyComboBoxName

Dates
="Between " & Forms!MyFormName!MyStartDate & " and " & Forms!MyFormName!MyEndDate

HTH Joe Miller
joe.miller@flotech.net

 

[BLutgen]

Thanks a lot, worked great