Email Report based on result in combo Box

[Jennacat]

I was wondering,

Ok, I have a command button that, when clicked, opens a report that is filtered based on the product name in the combo box beside it. Is there a way to email this report based on what is selected in the textbox? For example, could I have an email button that opens the report based on whatever the user chooses in the combo box beside it? If so, how do I do this? Thanks for your help!

 

[pbaldy]

Since SendObject doesn't have an argument to restrict the report, you generally have to do the filtering in the report. If you are filtering from the report, you can just use SendObject. If you are using the wherecondition argument of OpenReport to filter, I have heard that if you open the report filtered and then use SendObject while it's open, it will email the filtered report (so you open, send & close).

 

[Jennacat]

Thanks! It worked!