Link two combo boxes on a form

[Guest]

I have one combo box with a list of Product Names another combo box with a
list of Product Part Numbers. How can I link them so user can select one
Product from first combo box and the other combo box will display the
corresponding Part Number? Or is there another why to fill in the field for
Part Number automatically once the Product Name is selected?

Thanks

 

[Guest]

This is called "cascading combo boxes". You can find info at the following
link;

http://www.fontstuff.com/access/acctut10.htm

or you can google it and you'll get plenty of other links also.

HTH

 

[Guest]

Can a Product Name have more than one related Part Number?
Do you have these table setup with primary/foreign keys?

If so, in the query for your Part Numbers combo, in the ProductID field
criteria, type:
Forms!myForm!Combo1

Then in the AfterUpdate event of Combo1 type:
Me!Combo2.Requery

Change myForm, Combo1, Combo2 and ProductID to the names of your form,
combos and field respectively.

Steve
Steve