Printing a single form record

[Ian Godfrey]

When I "print" from form view every record in the table
prints. How do you print just the "on-screen" record?
Thank you.

 

[Joan Wild]

You should create a report for printing the information. Forms really
aren't meant for printing.

Once you have the report done, you can add a button to your form with the
following in its onclick event:

DoCmd.OpenReport "ReportName", acViewPreview, , "SomeID= " & Me!SomeID

Substitute the name of your report for ReportName.
SomeID refers to the unique identifier for the record on your form

 

[DBaxter]

If you are like me, I like to print the form to show the
info as it is entered. Go to design view, on
the "toolbox" menu bar, click on the "page break" icon and
click on the bottom of your form, just above the Form
Footer bar.