How to connect two Combo boxes?

[Hema Selvan]

I have question about how to connect two combo box. One combo box have Product Code and the Combo box have Carrier name related to each product Code. If I select Product Code "A", then "Carrier" combo box should give the list only related to Product Code "A". Same way if I select Product Code "B", the Carrier Combo Box should give list only related to Product Code "B".
I understand that that I have to create Table for Product Code and another Table for Carrier and create Query for this. But I have no idea what query to be used. I am new to Access.

When giving answers please explain in detail. Thanks so much in advance.

[mshmyob]

What you want to do is called Cascading Combo boxes. You can read an excellent article here that explains it in detail with examples.

cheers,

[orangeCat]

Try a search on "Cascading Comboboxes". Look for an example .... especially the Me.Requery part.