Hey guys, I made a report based on a form with three subforms which two are tables. I have a view button that allows the user to search for the record which works. But when they search the record and the button that is suppoed to open the report it automatically puts that form in the printer queue so they can print it out, but it does not actually go to the actually report so they can view. I don't know why this is happening. Here is my code
strWhere = "GTSR_ID = '" & Me.GTSR_ID & "' AND Revisions = " & Me.Revisions & " AND TR_ID = " & Me.TR_ID
DoCmd.OpenReport "TR_Form", , , strWhere