Lookup & Autofill

[pwicr]

I have a table with "Color". I want an option group in the form that I can click one of 2 color choices. The option numbers are stored in a separate column called "INTCOLOR". The color choices are stored in a table called "tblINTCOLOR". I want my color field set in design view to look up the number from "INTCOLOR" in "tblINTCOLOR" and automatically put the color NAME into the "COLOR" field automatically. Such a simple query but I'm missing a step somewhere and can't get it to work!!!!

 

[MStef]

I suggest to do it via COMBO BOX.

 

[pwicr]

this is how I am set up...

Combo Box

Table/Query

SELECT tblINTCOL.ID, Dealers.Color, Dealers.INTCOLOR FROM tblINTCOL LEFT JOIN Dealers ON tblINTCOL.ID = Dealers.INTCOLOR;