Numpty
on t'internet
- Local time
- Today, 01:35
- Joined
- Apr 11, 2003
- Messages
- 60
I've added a textbox with the following code to a report:
="Showing Courses from " & Format([Forms]![AttendanceDate]![StartDate],"dd mmm yyyy") & " until " & Format([Forms]![AttendanceDate]![EndDate],"dd mmm yyyy")
Now I can preview the report fine and the textbox shows the correct dates, formatted correctly.
But when I print the report it asks for the date parameters again.
Now the parameters come from a form which closes when the report is opened, but I cannot understand why it needs them again when the report has already been produced.
When it prints all fields have #Error instead of the correct figures and the textbox displays #name.
The report and two sub reports use the dates but I never had the problem until I inserted the textbox.
Does anyone know why this has happened and what I could do to prevent it - without having to leave the form open!
Cheers for any help
="Showing Courses from " & Format([Forms]![AttendanceDate]![StartDate],"dd mmm yyyy") & " until " & Format([Forms]![AttendanceDate]![EndDate],"dd mmm yyyy")
Now I can preview the report fine and the textbox shows the correct dates, formatted correctly.
But when I print the report it asks for the date parameters again.
Now the parameters come from a form which closes when the report is opened, but I cannot understand why it needs them again when the report has already been produced.
When it prints all fields have #Error instead of the correct figures and the textbox displays #name.
The report and two sub reports use the dates but I never had the problem until I inserted the textbox.
Does anyone know why this has happened and what I could do to prevent it - without having to leave the form open!
Cheers for any help