Printing from form to report

[BGoode]

How can I print only the current record in a form to a report?

 

[lorraine]

Use the following command in the on_click event in a command button. Where PK is the record identifier in your underlying table or query and txtPK is the name of the control displaying this on the form (I hope that is clear!!)

DoCmd.OpenReport "NameOfReport", acPreview, , "[PK]=" & Me![TxtPK]

If this fails look up <OpenReport Action> in the access help