Sending Data in an E-mail

[Guest]

I created a database to keep track of employees. When there is an issue
related to that employee I need send the information to the person who can
help. For example John Doe can not log into System A. So I enter the
information on the database which I have set a primay key as "Issue No." and
it auto assigns a number. I then created a Macro to send the object in an
e-mail which worked great on the first test. Then as records were added it
would send all the records. How can I create a macro that will send only the
current record or a record I select to be sent?

 

[Steve Schapel]

Miguel,

I assume it is a report you are sending via email? And I assume you are
triggering the macro via an event on a form? The form where you are
entering the "issues"? So you need to base your report (i.e. its Record
Source) on a query, which has a Criteria set in the [Issue No] field, to
the required record, which I assume will be the Issue No of the current
record on the form, so the Criteria in the query will look somewhat like
this...
[Forms]![NameOfForm]![Issue No]