Printing same form from different location

[markswan20]

Hi guys i am using 2 forms both need to be able to print the same data the one form works fine now i've added 2 command buttons with the following code attached to the onclick event could someone please tell me where i'm going wrong as i keep getting the debugger appear

Private Sub Command3_Click()
Dim stDocName As String

stLinkCriteria = "[PRINTOPTIONSREADONLY]=" & Me![PRINTOPTIONSREADONLY]
stDocName = "BLANK_WORK_SHEET"
DoCmd.OpenReport stDocName, , , stLinkCriteria
End Sub

Kind Regards
Mark

 

[PHV]

as i keep getting the debugger appear
Any chance you could post the whole error message and which line of code is highlighted by the debugger ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886