Making the combo box copy the value of field

[azhar2006]

Hello
Trying to Make a combo box is the process of transferring data from one field to another field based on the value of it to choose



Used this expression, but did not succeed

[pbaldy]

If PaymentMade is a field containing those values, how about using quotes:

IIf(PaymentMade= "Cash"; [Expr3];...

[azhar2006]

Thank you very much
View Image
If (PaymentMade) is (Cash)
Move figures to be above or symmetry

[azhar2006]

Can we say pbaldy
He thus becomes the expression
IIf(PaymentMade= "Cash"; (sum[Expr3]= [amount]))
Function or use Case

[pbaldy]

I'm not clear on the goal, but perhaps:

=Sum(IIf(PaymentMade= "Cash", [Expr3], 0))

[azhar2006]

Thank you
Please refer to the following link
I put an example of facility (DB)
https://www.accessforums.net/queries...00/index2.html

[azhar2006]

Thank you
Please refer to the following link
I put an example of facility (DB)
https://www.accessforums.net/queries...00/index2.html