Hello everyone
I can't understand what is the problem in my IIF condition.
By typing this condition in Criteria
IIf([Forms]![Formname]![CheckBox]=True; =>[Forms]![Formname]![Textbox]-1; <[Forms]![Formname]![Textbox]-1)
it doesn't return anything
If I tipe in the Criteria field only the value_if_true
=>[Forms]![Formname]![Textbox]-1
it returns exactly what I want
the same with value_if_false
it works great
but in the IIF condition it doesn't work
please help
thanks and best regards
Merim