email only one record in access 2003

  • Thread starter Thread starter Pepomarga
  • Start date Start date
P

Pepomarga

When I try to email a record it makes me a snapshot of all records and not
only the one I want.
 
Benita,
Not a lot of detail to go on, but...

Create a report that is always filtered by some key value on the form
you are initiating the email from.
Example: A unique key field named CustID on form named MyForm

In the query behind the report, use that form value as a criteria to
filter
out all CustIDs except the one currently displayed on the active and open
form.
Example: = Forms!MyForm!CustID
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top