Chain of events:
a) Click a Button on a form
b) Runs a module with code as follows:
c) Runs a macro which prints 18 separate reports in turn
The reports each run from a separate query, what I was wondering is, could I add something into the process where if the contents of the query were blank then to not print off the report and move to the next one? To save on paper as it prints off 18 pages each time even though some of then may be empty.
Regards
Carly
a) Click a Button on a form
b) Runs a module with code as follows:
Code:
Private Sub Stage_6_Click()
retvalue = _
MsgBox("This Option will print the delivery notes. Select OK to continue or cancel return to the Form", vbOKCancel, "WARNING")
If retvalue = vbOK Then
DoCmd.RunMacro "Mcr 1h Print Delivery Notes"
Call UpdateControlRecord("6")
End If
End Subc) Runs a macro which prints 18 separate reports in turn
The reports each run from a separate query, what I was wondering is, could I add something into the process where if the contents of the query were blank then to not print off the report and move to the next one? To save on paper as it prints off 18 pages each time even though some of then may be empty.
Regards
Carly
