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

G

Guest

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to automatically print current record on update to a report 5
Trying to print current record 1
Print current Record 1
Print current record to a grouped report 1
Access Automatically Send a notification email once a record is added 0
A macro to do the open several reports to print 4
condition for current record only 1
How do I print just current record in a report, when there are ov. 1

Top