Displaying criteria on report

[hiwelcome]

Hello,

I have a form which allows users to choose filters for a report, such as a date range. When I try to display the criteria on the report, I use a text box with =[Forms].[FrmReportFilter].[TextDate1] as the control source, for example. This works fine unless/until the user closes the filter form. If they do so before printing the report, it shows up as "#Name?" when printing. Is there a workaround for this?

 

[MarkK]

Yeah, don't let the user close the filter form. Set the form's CloseButton property to false, and/or cancel the Unload event unless the printed report sets a flag. etc...

public ReportHasPrinted as boolean

private sub form_unload(cancel as integer)
[COLOR="Green"]   'don't allow the filter form to close until the report has printed[/COLOR]
   cancel = Not ReportHasPrinted
end sub

And on the report . . .

Private Sub ReportFooter_Print(Cancel As Integer, PrintCount As Integer)
[COLOR="Green"]   'allow the filter form to close after the report footer prints[/COLOR]
   forms("frmFileForm").ReportHasPrinted = True
End Sub