SendObject: Where Condition?

H

HServ

I am using a macro to include a "Send as E-mail" command button on a dialog
form. The command will send a report chosen from a combo box. My problem is
that I want to filter the report first so it only sends certain records,
depending on the choice in the combo box. The argument for the action
"SendObject" doesn't allow a WhereCondition. Is there any way to this? Thank
you
 
R

Rick B

I think you would need to apply the filter in the report itself. Just limit
the report selects to include your where condition.

This may mean that you will need to save a separate copy of the report if
you sometimes want to run it without the filter.
 
Top