How to email only one record (report)?

[Guest]

I have a run email macro button (sendobject) on a form. Once all data is
entered into the form, it spills into a new record report. I want to email
the one record (data from the last form input) only. Right now it sending
all records in the report. Does anyone have any ideas?

 

[Tony Toews [MVP]]

I have a run email macro button (sendobject) on a form. Once all data is
entered into the form, it spills into a new record report. I want to email
the one record (data from the last form input) only. Right now it sending
all records in the report. Does anyone have any ideas?

For a page on how to print a report for a single record and how to generate reports
to attach to emails see the Emailing reports as attachments from Microsoft Access
page at http://www.granite.ab.ca/access/email/reportsasattachments.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Steve Schapel]

Lorisa,

Base the report on a query, using the criteria of the query to restrict
it to return only the record you want for the report.