I have an annoying issue and am wondering if someone can help or figure out a way around this.
I have a simple table, 2 forms, a query, and a report in a sample database. What I have is in a much larger database, but the issue is the same in the sample.
The process is as follows:
Open Form1; add a new record, populate the fields, add an attachment. My DB uses a small PDF.
Click the command button to open Form2. (In my DB this is an unbound form that has command buttons to open various reports).
In Form2, click the command button to open Report1.
Here is where things get weird. I try to print the report using the print icon on the default ribbon. The Form1 prints all the records as if I run a ‘printform’ sequence. BUT, if I select file then either quick print, or print, the report prints.
This ONLY happens when I access the attachment field… add an attachment, remove an attachment, just open the attachment list box. Doesn’t matter. However, if I add a record to the form and don’t touch the attachment, the report prints normally from the print icon.
I’m attaching the sample database…
Database1.zip
Does anyone have any ideas?
(Edit: Happens in Access 2010, Runtime 2010, Access 2013, and Access 2016, Windows 7 and Windows 10)