Print Selected Record

  • Thread starter Thread starter Sammie
  • Start date Start date
S

Sammie

I want to print a popup form. I used the command button wizzard to set up a
button to print the form. How can I filter what's printed to be only the
selected (active) record?
 
Although allowed, Forms are really not designed for printing. Why not just
create a report to present the data for the current record. Then you can use
the Where argument of the OpenReport method to have the report limited to the
active record on the form?
 
I want to print a popup form. I used the command button wizzard to set up a
button to print the form. How can I filter what's printed to be only the
selected (active) record?
Click to expand...

Print a Report, rather than a Form; and use the WhereCondition argument of the
OpenReport method to choose an individual record. E.g.

DoCmd.OpenReport "MyReportName", WhereCondition := "[ID] = " & Me!ID
 
Got that. Is there a way to prevent a form from printing? My users
sometimes accidently print the form instead of the report, and get thousands
of records sent to their print queue by mistake.
 
Back
Top