On my form, with datasource a query, I have a checkbox called Stock:
Show only records with quantity on hand

If this is ticked, (value=-1) I want to show only records where quantity is greater than 0. If it is not ticked, I want to show all.

Under my Total Qty field in my Query, I have currently the criteria (it's not working):

IIf([Forms]![Form Shelf Life]![Stock]=-1,> 0,[EVALUATION]![TOTAL QTY])

I've also tried:

IIf([Forms]![Form Shelf Life]![Stock]=-1,[EVALUATION]![TOTAL QTY] > 0,[EVALUATION]![TOTAL QTY])

If I don't tick the box, I get all the records. That's fine. But if I tick the box, I only get the records WITH 0 Qty. I want over 0.

Help please, somebody, anybody...