Send a record from a form as an email

[S.Matthew]

When you click a command button on a form is it possible
to send only that record as an email. If so how?

Thanks in advance
S. Matthew

 

[Steve Schapel]

S. Matrthew,

Yes. I suppose the most straightforward approach is to make a Query,
which used the key field in the form's data in the Criteria of the
query, using syntax such as [Forms]![YourForm]![YourKeyField]
.... and then use code based on the SendObject method to make your email,
and export the query, or a report based on the query. Hope that makes
sense.