Auto Update a Field

[jbruno]

I have a "Color" table with a field for color and a field for a number value. For example:
Red 3
Yellow 4
White 6

etc....

When working on my form, which is associated with my main "Data" table, I have a combo box in which I select the color from this "Color" Table. How do I make Access automatically update the cooresponding number value to the "Data" table?

Thank you for your help.

 

[pdx_man]

In the design view of the form, select the combo box. Go up to the menu command view and select Properties (Unless the properites window is already showing) The second line from the top of the All tab will be Control Source. Click on the drop down and select the field that you would like to have that value Bound to.

HTH