Conditional criteria

[chancer1967]

I have a form/subform that shows invoices for a selected customer.

I have created a checkbox on the main form, that if ticked will exclude paid invoices (zero balances) from the subform. That's the intention anyway,

But my conditional criteria is working backwards - when ticked I only get zero balances

Its been a long day and I just can't see the flaw in the logic:

IIf([Forms]![frmCustomerDetail]![chkZero]=True,[Balance]<>0,[Balance])


help!

 

[chancer1967]

Peachey!

I can see that I am going to have to start looking at the SQL view a lot more