E-mail one record

[Susan]

I am a new user working in Microsoft Access 2003. I am trying to set up a
macro to be used on my Entry form. When the command button is pushed I would
like to e-mail another individual one record from my form. I created a report
to be used in sending the e-mail. I set up a macro to the best of my ability.
This is what I used:

Echo - No
Run Command - Refresh
Run Command - Select Record
Send Object - Report (RPT:Entry in Rich Text format)
Select Object - Form (FRM:Entry)
Maximize

When I use this macro I am able to send the e-mail; however, it contains all
records from my form. How do I select only one record to e-mail?

 

[Steve Schapel]

Susan,

Probably the easiest way here is to go to the query that the report is
based on, and in the Criteria of the applicable column, enter the
equivalent of this:
[Forms]![Entry]![NameOfFieldThatIdentifiesTheRecord]

I am not sure of the purpose of some of the other actions in the macro.
It doesn't seem right to set Echo to No without setting back to Yes
again. In any case it probably is unnecessary. I would try removing
it. The Refresh action is also probably pointless, though I am not sure
- can you say why you have3 that there? And I would expect that if the
macro is being run from an event on the Entry form, then the
SelectObject action is also redundant, as the focus should already be there?