Email of a form

[rdaughdril]

I have a record on a form that I would like to email. When I set up the macro it wants to email all of the records. Is there a way I can specify just the record I have open.

Thanks

 

[John Big Booty]

You'd be better off creating a report and emailing that, you can collect the data for the current record using a query and using the following as criteria in your query;

Forms!FRM_FormName!RecordID