E-mail with object

[Johnny]

I have a report I want to send with an e-mail, but how can I make a filter
or where-conditions so I can send a single report, not all of them? I am
using a sendObject command.

Sincerelly

Johnny

 

[Van T. Dinh]

Sorry, you don't have the Filter / WhereCondition like the OpenReport
method.

You will need to modify the Query you use as the RecordSource to include the
criteria BEFORE you execute the SendObject.

 

[Rebecca Smith]

Hello

I'm assuming you're using a command button to send the report? If so, then
try basing the report on a query and set the form ID as criteria for the
query. e.g. if you want to send the current form's details, have the
criteria in the query as Forms![form name]!FormID

Hope this makes sense.

Let me know if you need more help

Rebecca