When I open the form regularly, then press the button, it won't print. But if I open the form in Shift-bypass mode and click the button, it works (which I cannot even begin to try and give an explanation for).
Also, if I open the form regularly, I can press the button, and it won't work, but I can do the File > Print, then select print the Selected Record(s) radio button, and then it will print.
FYI, the "no" option on the msgbox works.
Can anyone give me any advice here? Anything helpful would be appreciated.
What I mean is, quite simply, copy and paste the form to a new object in your DB, strip all the code and stuff out and use that as the "printable" version. The user won't see and doesn't care if the object that prints is not the same object open on the screen - they only care if the data or printed format is not correct.
As the developer, you tie your hands if you try to make your GUI and your printed output the same object. By seperating them, you have the freedom to build controls into the GUI and format it to fit the screen while formatting the output to fit paper.
To Teddy's point, you can create a report and then copy and paste all of the formatted stuff from the form into the report. Use the form to enter/edit info and the print button calls the report, which is suited for printing.