Putting Info in one field if data is entered into another field

[aikiai]

How does one cause certain data to appear in another field based upon the data entered in another field.

For example: I enter in the field the word "Carrot" in a field called food and the word "Orange" appears in the field color. And then if I enter the word "Beans" in the field food then the word "Green" appears in the field color.

Thanks for you help in advance.

Eric

 

[M8KWR]

I think you could use 1 of two methods here.

1st - A select case

2nd - if the field is a combo box, pulling information from a table, and you had the table as follows: -

ID No Name Colour
1 Carrot Orange
2 Bean Green

When the user selects the Name, then access pulls the other information from the combo box (which you can hide from the user) into the other field.

The 2nd one would be easier to update in the future, as you don't want to keep on altering code each time you add a different option.

I can give you more help if you need it, just let me know.