View Full Version : Printing from form to report


BGoode
06-25-2001, 05:59 PM
How can I print only the current record in a form to a report?

lorraine
06-26-2001, 05:27 AM
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