[FatBear]

I'm trying to create a simple if statement to populate a TEXT field
depending on the value chosen in a dropdown (NAME dropdown2) box.

The values in the dropdown box are 0.75, 1.01 and 2.01.

I want the text field to show 0.75 if the dropdown is 0.75 and 0.25 if the
dropdown is either 1.01 or 2.01

I've tried all of the following and many mo

{IF Dropdown2 = 0.75 0.75 0.25}
{IF {Dropdown2} = 0.75 0.75 0.25}
{IF Dropdown2 = "0.75" "0.75" "0.25"}
{IF {Dropdown2} = "0.75" "0.75" "0.25"}

The problem is the TEXT field NEVER, EVER updates no matter how often I
change the value in the dropdown.

I've tried refreshing the field by pressing F9 but still nothing.

Is the IF statement wrong or is there a different way to refresh the field?

Any help would be appreciated.

FatBear

[FatBear]

Oooops, never mind. I got it to work.

FatBear wrote in
.131:

I'm trying to create a simple if statement to populate a TEXT field
depending on the value chosen in a dropdown (NAME dropdown2) box.