I have a report i want to email as an attachment

L

lewie

I process a form by autoupdating it. I then display it for any
corrections. I then want to somehow send a report for the current
record contained on form. I could use a button to generate it.
Currently I build a separate recordsource while building the
recordsource for the form which works but any edits won't be reflected
in the report.
my questions are:
1. what should i use for the recordsource of the report since the
recordsource for the form may contain numerous records and i only want
the current one.
so the bottom line is that i want to send the current displayed record
in a form as an attachment in an email.
Thanks Lewie
 
Top