If statement on a field in a form

[LaughingBull]

I have a form with a received from field and a Carol Fee field.
Received from is a drop-down select and Carol Fee is a currency field.


I want Carol Fee to be $20 when Received from says Primary.
I have tried many ways code or expression builder. and I must not be doing something correctly.
Help Please.

[pbaldy]

I would add a field to the table the drop down gets it's selections from and do this:

http://www.baldyweb.com/Autofill.htm

That would be more dynamic and maintainable. To do what you ask, code in the after update event of the combo:

If Me.ComboName = "Received" Then
  Me.CarolFee = 20
End If