Hello,

I am using Access 365, and we use our database to track nonconforming parts.

I have a Form that I have the inspectors save and print. Currently I have the default printer set to Print as PDF so they can save to our network location. Once they save, they click CTRL P to select the printer they want to print to.

My inspectors are older and not very computer savvy. I want them to be able to click the save button to save to file location, then hit a Print button to print to the proper Printer. We only use one Printer to print in our lab.

The following code is what I have for the save button currently.

Private Sub Save_Click()On Error GoTo Err_Print_Record_Click
    DoCmd.RunCommand acCmdSelectRecord
    DoCmd.PrintOut acSelection
    Exit_Print_Record_Click:
    Exit Sub
    Err_Print_Record_Click:
    MsgBox Err.Description
    Resume Exit_Print_Record_Click
    End Sub
How would I modify this code to select the Quality Printer to print, I would use a Print Button for this. or what code do I need to save to a drive location.

I know it is easier to do all this in a Report, however, when doing this through a report it does not print or save correctly, I have tried several different ways to fix, and the Form is the only thing that works. I did not set up the DB and really don't have time to rebuild a new one