Users Printing Individual Report From Data Entry Form Submit Button

[Holli]

Need some help.


I have been asked to give users the option of printing their individual report. I built a form for data entry (survey questionnaire) in Access 2010. The form contains a submit button that saves to the reports. Now they need to be able to print their individual report from the Form submit button. Not sure the best way to do that, any help would be greatly appreciated Thanks!

This is my current code.

Private Sub SUBMIT_Click()
RunCommand acCmdSaveRecord
Me.Requery
DoCmd.Close
MsgBox "Thank you for your participation. Please complete your Department Survey and any Department Survey you may have a skill set in."
End IF
End Sub



Holli

[June7]

Something like:

If MsgBox("Do you want to print report?", vbYesNo) = vbYes Then DoCmd.OpenReport "report name", , , "ID=" & Me.ID

[Holli]

Yes. Will that automatically print their individual report if the they select yes.

Thanks

[June7]

Direct to printer is default. You can specify otherwise with arguments.

DoCmd.OpenReport "report name", acViewPreview , , "ID=" & Me.ID

I don't know your report name nor the unique identifier field. Adjust code as appropriate.

[Holli]

My Report Name is Career Path Assessment and the unique identifier field is EmployeeID

Thanks June 7

[June7]

Did you try code? Issue resolved?