T
Tal
I am trying to code a command button to do all sorts of things at once, as
follows:
Private Sub btnPrintReceipt_Click()
DoCmd.SetWarnings False
DoCmd.OpenQuery.qryDonorAddressTotalUnreceiptedCZCADonations (This runs an
append query that generates the Receipt.)
DoCmd.OpenQuery.uqryAssignIssueDateCZCA (This runs an update query that adds
today's date to the Receipt)
DoCmd.OpenReport.rptCZCAReceipts (This opens the Receipt)
DoCmd.SetWarnings True
End Sub
I am getting a Compile Error - Argument Not Optional error and the highlight
is appearing on the Append query line.
Help please!!
Many thanks,
Talia
follows:
Private Sub btnPrintReceipt_Click()
DoCmd.SetWarnings False
DoCmd.OpenQuery.qryDonorAddressTotalUnreceiptedCZCADonations (This runs an
append query that generates the Receipt.)
DoCmd.OpenQuery.uqryAssignIssueDateCZCA (This runs an update query that adds
today's date to the Receipt)
DoCmd.OpenReport.rptCZCAReceipts (This opens the Receipt)
DoCmd.SetWarnings True
End Sub
I am getting a Compile Error - Argument Not Optional error and the highlight
is appearing on the Append query line.
Help please!!
Many thanks,
Talia