I need to use a drop down box based on table Color that, once you click on a value, populates the field in my form
In the main database design, I reference the Table Color, both the ID and the description. For the description field, I ran the lookup wizard, refering to the Table Color, Selecting just the Color field (not the ID).
The display control is a combo box (default by access), with row/source type of Table/Query, and row source
SELECT Color.ColorID, Color.Color FROM Color OREDRE BY [Color]
Bound Column is 1, with Column Count of 2.
BUT when I open the form, the color description field was blank. The properties on that are:
Control Source ColorDesc
Row Source Type: Table/Query
Row Source is blank
Validation Rule and Text are blank
So, two issues: First, obviously my drop down list is not working.
Second, I want it to save the value I click in that form once the list works.