2 combo boxes

[Smokers]

In my form I have 2 combo-boxes. The first combo-box is linked to the 2nd field in my table, the 2nd combo-box is linked to the 3rd field in my table.
The selection of the 2 combo-boxes should show the content of the 4th field in my table.. No matter what I tried I could not get it to work.. Can somebody help me ??

 

[Smokers]

I'll try to be more specific, my first combo-box selects a UN-number, the 2nd combo selects a Packing-group, the combination of these two values should display the proper shipping name in a textbox. I made a query and it works, but I can't seem to insert this query in my form

UN-number = field 2
Packing group = field 3
Proper shipping name = field 4

 

[supercharge]

Enter into the ControlSource of your combine-textbox

=[control linked to field 2]&[control linked to field3]

Link the textbox to your field 4, make it hidden if you want.

 

[Smokers]

Thanks alot.. I'll try that
Do I insert this in both combo-boxes ?

 

[Smokers]

Hmm.. that's how I had it.. but for a strange reason my 2nd combo-box shows the same data as my first combo..
My first combo is linked to field2 and my second combo is linked to field 3 and my textbox is linked to field4... Yet it doesn't seem to work
And eventhough I have the properties of my combo-box set to "limit to list = yes" it seems to change my data..

*grabs his bazooka and declares war on access 2003*

 

[supercharge]

Should have made it clearer, my bad.

Create a dummy textbox, make its Enable=False if you want. Do not link this box to your field4. Then enter this into the dummy's controlSource.

=[control linked to field 2]&[control linked to field3]

Then your "linked to field4" box should be set equal to this dummy.value

Your "linked to field2 and 3"'s controlSource should be the fields' names.