I searched the Discussions but can't find anything that directly addresses my issue. This is a fairly complicated issue but I know someone will be able to help me. I have a form (form_A) that has an embedded subform (sub_form_A). I would like to use SendObject to send what is in the subform, not the main form. SendObject allows you to send a form, which I am able to do. However, it is sending EVERY record in the table that the subform is bound to. I would like to only send the filtered data on the form. It is a listing of projects by user. One user may have 10 projects, another 5, another 20. The subform properly displays all the projects associated with that user, but when I do a SendObject with a "acFormatXLS", it creates a spreadsheet with every record in the table that sub_form_A is bound to. the Main form's (form_A) only control is used to display the user . This control is then used to filter the subform. BTW: If I SendObject the Main form, it only sends that user's name, though there are about 50 users in the table. So, SendObject on the main form works correctly. Any help would be appreciated.