Emailing information from current form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created an access database for telephone call logging. Within my
form, I have a Macro setup to email the contents of the current form, which
outputs to HTML format directly into MS Outlook. The macro link is working
fine, my only problem is that it is not just bringing over the current
record, it's bringing over all records.

How do I get it to just email the active record?

Any help would be greatly appreciated.

Thanks
 
hi,
I had to tackle that problem couple of years ago.
I had to create a query to select the current record.
i Used [Forms]![Myform]![recordID] as criteria.
I created a report that looked like the form and used the
query as it's record source. i emailed the report.
 
Back
Top