Report printing problem

  • Thread starter Thread starter allie357
  • Start date Start date
A

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?
 
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?
Click to expand...

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
 
Back
Top