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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
maintaining current record when changing focus in forms 3
Email Current Record from Form 4
How do I bookmark currently displayed form's record to copy 1
Separate Form 0
Access Command to run access, open to specific form and specific record 1
How to Keep Spell Check On Current Record 3
Combo Box Filter 1

Back
Top