add or subtract

[MdHaziq]

Hello, forum



I would like to add or subtract the quantity the user's request.

I decided to put a drop-down combo box for the user to select which option they want.

The expression will be changing the on hold quantity that is tied with the item.

[ranman256]

in a query:
IIf(forms!myform!cboBox="-", (field1- field2), (field1+ field2))

in a form:
txtbox3 =IIf(cboBox="-", (txtBox1 - txtBox2), (txtBox1 + txtBox2))

[MdHaziq]

I am not sure on how to use IIF.
Did some reading and that is all but I do not know how to apply in my program. I tried this exp. but it does not work.
IIf([Forms]![frmHome]![cboaction]="Withdraw",[tblitem].[Qty]-[froms]![frmHome]![txtqty],[tblitem].[Qty]+[froms]![frmHome]![txtqty])