Button to print current page

M

MikeB

I need to place a button on a form that prints only the current page. Can
anyone help?
 
D

Daniel

The best way to approach this is to create a report based on the information
source used for the form. then set up the button to print the report while
adding the criteria of your current record as a filter 9so it only prints the
current record.

Your button can use code similar to:

DoCmd.OpenReport "YourReportName", acViewPreview, ,
"[ReportRecordIDFieldName]=" &
[FormRecordIDControlName]

If you google groups this subject you'll get tons more info.

Daniel
 
Top