Report printing problem

[allie357]

I have this text box in my report header to display the report title:
="Report Period From" & " " & Forms!XViolationsForm!txtStartDate & " "
& "Through" & " " & Forms!XViolationsForm!txtEndDate


I also have a form that users input filter criteria into and then the
report is opened in Preview mode.

Well, when I print I get the
#Name? error.

How do I fix this?

 

[fredg]

I have this text box in my report header to display the report title:
="Report Period From" & " " & Forms!XViolationsForm!txtStartDate & " "
& "Through" & " " & Forms!XViolationsForm!txtEndDate

I also have a form that users input filter criteria into and then the
report is opened in Preview mode.

Well, when I print I get the
#Name? error.

How do I fix this?

The form "XViolationsForm" must still be open while the report runs.
The form must have text controls named "txtStartDate" and "txtEndDate"
Close the form in the Report's Close event.

Why the extra & " "'s?

="Report Period From " & Forms!XViolationsForm!txtStartDate
& " Through " & Forms!XViolationsForm!txtEndDate