Print Preview and Print Different!

[_Boo]

Hi I have this code on my report page to tell me the building and room of the report, if none all selected it fills it in with all buildings - all rooms.

=IIf([Forms]![frmBlueSheetReportTool]![BuildingSelect].
[ListIndex]>=0,[Forms]![frmBlueSheetReportTool]![BuildingSelect] & "-" & DLookUp("RoomNumber","qryLookupForBlueSheet"),"All Buildings - All Rooms")

It works in print preview mode, but when I go to print it prints #Name?

[boblarson]

Is the form still open at that point? If not, it needs to be.

[_Boo]

Since it is a dialog form and closes, how should I do this? pass parameters to the report?

[boblarson]

Open it not as a dialog. Open it as a simple form and then you can HIDE it when opening the report and then in the report's On Close event you can close the form:

Private Sub Report_Close()
   If CurrentProject.AllForms("FormNameHere").IsLoaded Then
      DoCmd.Close acForm, "FormNameHere", acSaveNo
   End If