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.
It works in print preview mode, but when I go to print it prints #Name?Code:=IIf([Forms]![frmBlueSheetReportTool]![BuildingSelect]. [ListIndex]>=0,[Forms]![frmBlueSheetReportTool]![BuildingSelect] & "-" & DLookUp("RoomNumber","qryLookupForBlueSheet"),"All Buildings - All Rooms")