filtering sendobject

[aplusmk]

I am trying to send out an email with the listing of a report based on information on a form.

Is there anyway to dynamically filter the report for the send object?

This is what I have so far:


DoCmd.SendObject acSendReport, "wpr_assignment_report", acFormatRTF, strToWhom, , , "Assignment Report", strMsgBody, False

 

[RoyVidar]

Only way I know of, is putting the criteria into the query the report is based upon.

(well - I think I've seen someone using the reports on open event to set filter too, but I haven't tried that myself...)

Roy-Vidar