Combo Boxes

[Guest]

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.

So far all I am getting is errors. Help

 

[fredg]

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.

So far all I am getting is errors. Help

I'll assume the combo is displaying the FabricID, Pattern, and Color
fields in that order.

Set the Bound column (FabricID) of the combo box to Column 1
Set the Combo Column Count property to 3
Set the Column Widths property to
0";1";1"
Set the Combo's AutoExpand property to Yes
Set the Combo control source to the [FabricID] field.

When the form is open and the combo is drop-doesn, you will only see
the second and third columns.
Start typing the pattern.
When you reach the correct pattern, select the record whose color goes
with that pattern.
That FabricID will be stored in the table.
The Combo will then display the Pattern selected, not the pattern and
color.

 

[Guest]

Sorry Fredg

Didn't realise that this was a multi post and that someone had already
answered.

Lele - please don't post the same question twice.