I have a form with a "Save" button. If the Send_Call check box is checked, then part of the save process that I desire is to e-mail the contents of the form (or record, it's the same thing).
The report "SendMail" depends on a query which asks for the record number. How do I pass the record number (which is known by the system as Call_Num) to the query in the code above so that the user does have to enter the number manually?
Or is there another way?
Thanks,
Bubba
Code:
If Me.Send_Call = True Then
DoCmd.SendObject acSendReport, "SendMail", acFormatRTF, "joe.smith@domain.com", , , "Title", "Body", 0
End If
DoCmd.GoToRecord , , acNewRec
GoTo Exit_Save_Click
The report "SendMail" depends on a query which asks for the record number. How do I pass the record number (which is known by the system as Call_Num) to the query in the code above so that the user does have to enter the number manually?
Or is there another way?
Thanks,
Bubba