I would like to click on button on a form to send an email containing 3 reports. I used the following:
Private Sub CmdEmailScoreReports_Click()
On Error GoTo Err_CmdEmailScoreReports_Click
Dim stDocName As String
stDocName = "RptNegativeResponsesByProject"
DoCmd.SendObject...
I need a little more help.
I was going to try this code:
NextNumber = Nx(DMax("[SurveyNumber] = '" & me.SurveyNumber & "'"), 0) +1
I don't know where to put it.
BeforeUpdate?