IF statement on dropdown

F

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 more:

{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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF Function with multiple text entries 6
macro to display text on drop down 1
Populating form dropdown at run time 5
Change sub dropdown based on main dropdown in access forms 2
Combobox Wrong Customer 7
If Statement 2
Is there a way to use a string to pass sql query a table columnname??? 10
Yes/No field custom format text color 1

Top