I have a field in my database that is named "state" and a field named "max liability which is a currency field. I want a certain currency to automatically be placed in the max liability field when a specific state is entered.
I tried the code:
If State = "AL" then
Max Potential = "5800"
However, this does not place anything in the max liability field. It still remains blank.