Let user select a printer when executing 'Print this record'

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, On my form, there is this button called 'Print this current label'. However, it does not let the user choose a printer and it sends it to a default printer. My users have a total of 6 label printers to choose from. I have a feeling that AcViewNormal can be changed to something else so that 'Preview' is showed first, then the user can select a printer. Unfortunately, I am a novice to VB. I need help desparately
Thanks for the help

The codes for the button is as follows
Private Sub PrintThisRecord_Click(
On Error GoTo Err_PrintThisRecord_Clic

Dim strDocName As Strin
Dim strFilter As Strin
strDocName = "LabelsFromTable
strFilter = "ID = Forms!Label!ID
DoCmd.OpenReport strDocName, acViewNormal, , strFilte

Exit_PrintThisRecord_Click
Exit Su

Err_PrintThisRecord_Click
MsgBox Err.descriptio
Resume Exit_PrintThisRecord_Clic

End Su
 
Back
Top