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.
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.
in a query:
IIf(forms!myform!cboBox="-", (field1- field2), (field1+ field2))
in a form:
txtbox3 =IIf(cboBox="-", (txtBox1 - txtBox2), (txtBox1 + txtBox2))
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])