How do I run a macro to print only the current record in Access

B

Brian

I have case managers that input cliet information for medications in a form.
I have a linked Report that will summarize the needed info for the doctor.
The problem I'm having is running a macro on the form to print the current
record on the report. Thanks
 
S

Steve Schapel

Brian,

I assume you are using an OpenReport action in your macro to print the
report.

There are basically two approaches here. One is to put a reference to
the primary key field of the current record on the form, into the
criteria of the query that the report is based on. In other words,
something like this...
[Forms]![NameOfForm]![YourID]
The other approach is to use the Where Condtion argument of the
OpenReport action in your macro. This will look something like this...
[YourID]=[Forms]![NameOfForm]![YourID]
 
Top