Help on Command Button

[garciaroizm]

I have a command button to email a form. What I want is to email a single record in the form. Basically I have a form that creates ticket for certain jobs completed, when I click on the command button it emails all the tickets, which is not what I want. Please help.

[burrina]

Generally Reports are emailed, not forms? Anyway, you need to provide your code so we can see what you are doing.

[Missinglinq]

As Dave said, you really need to use a Report for this. Once your Report is designed, go here

http://access.mvps.org/access/reports/rpt0002.htm

to learn how to only generate the Report based on the Current Record.

Linq ;0)>

[June7]

You can email report as an attached PDF or use data in the record to construct email body.

[azhar2006]

https://www.accessforums.net/forms/o...ton-45197.html

[garciaroizm]

Sorry for not responding sooner I'm on vacation with my kids. Anyways here is a copy of my database.