I have a form that after a user fills out the fields they need to be able to print it, current record only. I have a created a button and written the code below for the on click property:
Private Sub Command16_Click()
DoCmd.OpenReport "current_issue", acViewPreview, , "[ID] = " & Me.ID
Dim stDocName As String
stDocName = "current_issue"
DoCmd.OpenReport stDocName, acPreview
Exit_Command16_Click:
Exit Sub
Err_Command16_Click:
MsgBox Err.Description
Resume Exit_Command16_Click
End Sub
The problem I have is that after they fill out the form and click the button the report comes up blank on the screen. If they close the form and open it and go to the record they want to print it works. Any help is greatly appreciated!