Email one record of report instead of all records

[Lambi000]

Good Day:

I have a form that allows a user to create a new record. I have a button
that allows a print preview, one that prints and one that supposed to email
the printed form to another. I use the Where condition for the print and
print preview (record ID on form = recocrd ID in report), but what can I use
to email just ONE record, like the ones I can print, to a user instead of the
whole database.

 

[Clifford Bass]

Hi Lambi000,

Try sending the report while it is open and only displays the specified
record.

DoCmd.OpenReport ....
DoCmd.SendObject ....

Clifford Bass

 

[Tony Toews [MVP]]

I have a form that allows a user to create a new record. I have a button
that allows a print preview, one that prints and one that supposed to email
the printed form to another. I use the Where condition for the print and
print preview (record ID on form = recocrd ID in report), but what can I use
to email just ONE record, like the ones I can print, to a user instead of the
whole database.

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/