Print a single report from a form

[Peter S]

I'm in a form with columns of data. I select a record. I
need to put together a macro, activated from the form,
that will print this record (and only this record) in a
report. Anyone know how ?

Regards

 

[Steve Schapel]

Peter,

Make a query, based on your table. In the criteria of the primary key
field in your query, put the equivalant of...
[Forms]![NameOfYourForm]![NameOfPrimaryKeyField]
Base your report on this query. Make a macro with the OpenReport
action, and nominate the name of your report. Put a command button on
the form. On the On Click event property of the command button, enter
the name of your macro.