Printing from a form to a pre-designed report

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

Guest

I have a command button on a form that prints a unique record based on a
pre-designed report. The problem is if you make any changes to that
individual record, the changes are not reflected when you execute the command
to print. One must 1. Exit the form, re-enter, go back to the record and
then print or 2. Navigate to the previous or next record, go to the record
in question and then print. This becomes a nuisance and a problem to
remember. Any suggestions?
 
I have a command button on a form that prints a unique record based on a
pre-designed report. The problem is if you make any changes to that
individual record, the changes are not reflected when you execute the command
to print. One must 1. Exit the form, re-enter, go back to the record and
then print or 2. Navigate to the previous or next record, go to the record
in question and then print. This becomes a nuisance and a problem to
remember. Any suggestions?
Click to expand...

Your data is not saved until you navigate to a different or new
record, close the form, or explicitly tell it to save.
Code the command button click event:

DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "ReportName" etc....
 
Good eveving

Prior to printing, simply use the following command line:

DoCmd.RunCommand acCmdSaveRecord

< place your print statements here >

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.
 
Back
Top