Printing a Form in Data Entry mode

[Guest]

I have a form and a subform for data entry. data entry is set only for the
subform. When I try to print the newly entered data by printing the form
neither suform nor the data I entered would show up. Only the main form gets
printed. I can print everything in the very same form and subform if I set
the Data Entry to "no" for subform. Is there any way I can print the suform
after entering data? Data that does not print do show up in the underlying
table.
I tried to go around this problem bu using OpenPrint action on a command
button. It prints the form and subform into a Report but only one new record
shows up in the report. In my subform I can enter more than one new record.
Selecting multiple records before clicking on the command button still
produces only one record in the report. How can I print more than one newly
entered record from a form?

 

[Jeff Boyce]

Moe

One approach would be to not try printing the form/subform. Instead, create
a report/subreport that returns the data you just entered. Print that
instead.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Thanks Jeff. As I mentioned in my question I tried that before seeking help.
I tried to use 'openReport' action in a macro on the properties of a command
button and it works BUT only one new record goes in to the report. On my form
/ subfrom I can enter multiple records, like several purchases by one
customer, and I need to print them all on the same report or form. One way
would be to open the form in a non data entry mode and filter it for newly
entered or not printed records. But, I am new to access and do not have any
VBA experience so I prefer to do this through Access UI. Usually printing
what you see on the screen is not hard at all.
Any Idea?