Problem with printing

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! :D

Cheers for any help
 
Actually I've just taken out the text box and its still doing it. :mad:

I mustn't have checked it since I put in the command to close the date search form.
Still unsure as to why it would need the dates again though when it has already formatted the report.
 
Leave the form open, just set its Visible property to false when opening the Report, close the form when closing the report
 
Cheers Rich, I was just going to leave the form open as it would just sit behind the report then close on exit from the report.

Didn't even think to make it invisible though! A much better idea.

Thanks
 

Users who are viewing this thread

Back
Top Bottom