I have created and written a VB command button to save a record on a
form and send an email using:

DoCmd.SendObject acSendForm

It works well but sends the entire table whereas I only want to send
the current record. Is there a specific command to do this?

Thanks

sjmo2 (AT) hotmail (DOT) com

No. But there is an easy workaround.
Just apply a filter on the (primary key value of the) record you want to
send before executing the SendObject method . You can use the default
shortcut menu of a form to do so. Just click on the Filter Selection item.

Good luck!

"SJ Mo2" <sjmo2 (AT) hotmail (DOT) com> schreef in bericht
news:ed609370.0401291056.1acde244 (AT) posting (DOT) google.com...