I have the following iff statement.
=IIf(([OctPayStatus]="0") And ([OctPayment]>"0"),"Unpaid","Paid")
OctPayStatus is a checkbox and OctPayment is a numeric value. I am trying to get the following answered: If the OctPayStatus is not checked and OctPayment has a value greater than 0 then show Unpaid else show paid.
Access tells me I have a circular reference on the control property......
A little push would be greatly appreciated.