Combo Boxes

[Lele]

My combo box has the following 3 columns:
FabricID (which is an autonumber), Pattern, Color
Typical data could look like this:
1, Plaid, Green
2, Plaid, Yellow
3, Stripe, Green
4, Stripe, Red

The fabricID identifies a unique combination of pattern and stripe.
I want the user to start to type in the pattern while the system assists
with an autofill but I need the the fabricID field to be the bound and stored
value.
How do I make this work? So far all I get is errors.

 

[miss031]

SO if the user starts typing "st" it will bring up "stripe, Green" in the
combo, then if the user wants "Stripe, Red" they will have to arrow down, and
when they choose "Stripe, Red" you want "4" to be stored?

If that is the case, in the properties of the combo, make
"Column Count" = 3, "Column Widths" = 0";1";1"; and "Bound Column" = 1

The row source would be something like:

SELECT [table_fabrics].[fabric_id], [table_fabrics].[fabric_pattern],
[table_fabrics].[fabric_colour] FROM table_fabrics;