I have a form that has two endpoints. the user needs to enter a number in either of two boxes, payment or receipt.
the two boxes are one after the other on the form, so preferred behaviour would be:
in the payment box
on exit: If ([paymt] <>0, go to next record, otherwise cycle to receipt)
in the receipt box
on exit: go to next record
so I wrote the following:
Code:
Private Sub paymt_Exit(Cancel As Integer)
=IIf([paymt]<>0, DoCmd.GoToRecord , , acNext, Forms![frm_cost_reconciliation]![receipt].SetFocus)
End Sub
but this returns the following error message:
Expected: line number or label or statement or end of statement
can anyone tell me what I'm doing wrong,
thank you for your time,
Cottonshirt