Emailing forms or reports

[dcecil]

I am using Access 2003 and I have a button that pops open a form showiing the contents of 1 record (where the button resides), but I want to then make a "Send" button on the form that will send out by email. Can I do this or does it have to be a Report? If it has to be a report, how do I limit the report to that one record that is shown on the form only?



Thanks,
Dave

[RuralGuy]

This link could help.

[dcecil]

Sorry, I should have said that I wasn't a "coder". I have fiddled around enough to be dangerous, but sometimes the coding gives me a problem. In which function of the form do I put the code? Also which parts are ones that I substitute for mine? I see that "rptSomeReport" would be the name of my report, but what exactly is RunID and me!RunID? Are these functions found in Access or something I substitute? If there is a way to do what I want with Macros or anything other than code, that would be easier for me. Any help is greatly appreciated!

[RuralGuy]

Do each of your records have a unique ID such as a Primary Key? That is what the link means by RunID.

[dcecil]

Okay, but what is the "& Me!RunID"? Is there anything I need to change in that string?

Thanks

[RuralGuy]

YES! That needs to point to your uniqueID control or field.

[dcecil]

Okay, I finally got the code to work. Thanks to you guys. I only have the one record info listed in the report. Now something else arose. On the form where the one record is listed, I have a combo box, using a value list. When I select a name from the list and press the button to product the report, the name selected from the combo box is not shown. On the other hand, on the form when I select the name and roll the wheel on the mouse down (everthing disappears) and roll it back up (everything is back), when I press the report button, the name appears on the report.

Any Ideas?