Filtering one record on command send via email

[mrenshaw]

I have a form that the sales reps fill out . I want to them to press a command button to email the current record in excel format. I can do the format but it will send all records. Something like this:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 2, , acMenuVer70
DoCmd.SendObject acForm, "ECN FORM", acFormatXLS, "email address", , , "subject"

I'm missing the select record filter part of the code. Not sure how to go about this. Any help would be greatly appreciated.

Michael

 

[DBL]

As far as I am aware, Michael, you can't filter a report via SendObject. What you need to do is create a query to base the form on and filter the query to the current record.