I am printing invoices and wish to exclude any with zero balances. Currently, the program works nicely except that it includes the zero ones.
The Total for each invoice is located in the Report Header band of the subform and shows correctly.
I have created a test command using
=IIf([Total]=0,"Other Zero") works perfectly, but if I try to use:
=IIf([Total]=0,DoCmd.GoToRecord , , acNext) It give me invalid syntax.
I have tried surrounding the Do clause with (), but same results.
I have suspected that the attempt to move to next record would have to be done from the main form rather than from the subform. Is that where it has to be executed. If so, is that the reason for 'invalid syntax'?
Is there a different/better way to choose to skip a record?
David