Sending a report

[cliffsimms]

I have the below code set on click. Which sends a report. What I need is to have the report only send the dates that have not passed. So instead of sending the whole report I would like to send only the information to dates that have not passed on the day which the button is clicked.

Private Sub Command0_Click()
DoCmd.SendObject acReport, "coursereportbyclasses", "RichTextFormat(*.rtf)", _
"bolive@.com; creeves@.com", , , "Course Attendee's", "The seat limit for each class is: 12 for Admin and 8 for Install. Once we have hit these numbers we need to look at alternative class dates for students", False
End Sub

 

[Chris RR]

The answer is not in changing the "SendObject" code, but in changing what you send.

You need to create something that does what you want, and send that to the user. The way to do THAT may just be by tweaking the query that the report is based on. You may not need to change the form or the report at all.