Problem printing report

[medic133]

I have a command button on a form (form1) whose OnClick event is to launch another form (form2) for the user to enter a parameter for a query. After entering a name in a textbox on form2, clicking a command button on form2 displays a report. In the report header, I have a textbox whose value is [forms]![form2]![fieldname]. When the report is displayed, everything looks good. However, I have designed a custom toolbar with a print button on it which opens the print dialog box so the user can choose to print from any printer. When the report is printed, #Name appears in the textbox. I think my problem is when the form is printed, it looks for [forms]![form2]![fieldname] but I have already closed the form. If I'm right, or wrong for that matter, any ideas on how to get the report to print correctly, just like the screen? The reason I close form2 after the report is opened is so when the report is closed via a command button on the custom toolbar, form1 appears, which is important to have happen. Thanks in advance!!

 

[glalsop]

Have you considered using the Report_Close event to close form2? That way it will be open while you need it, but you can close it when the report is done with it.

-Gary

 

[medic133]

Gary,

Thanks for the idea. I obviously hadn't thought of that. I'll give it a try!! Thanks much!!