I have a drop down list box on my form called FieldA. I would like for FieldB to update with a number depending on what is in FieldA. For example, if FieldA has Red, I would like FieldB to return a 2. I know this needs to have a case function done, but how do I get it linked to FieldB?
Case Form Field
- Thread starter jamphan
- Start date
That's not exactly what I had in mind. I have done this in the past using Case and saying Case "Red" Value = 2 and so on. All of the options in the list box (FieldA) will have a numeric value 1-4. I just need to link the code to FieldB after the selection is made in FieldA.
