Z
Zedbiker
I have 3 combo boxes on my form. What I want to do is make it possible for
the user to use any 3 of the combo's. For example : Combo box 1 "Part Name";
box 2 "Part No." ; box 3 "Supplier".
If the user selects box 2 "Part No." I want the other 2 boxes to synchronize
to show the Part Name and supplier for that Part No. If he selects 1 "Part
Name" the other 2 should show the relative Part No. and Supplier etc..
I can update text boxes with no problem but I can't find an easy to
understand way of doing Combo Boxes. I am sure this must be a common problem
but I haven't found the answer anywhere. I am using Access 2002.
Can anyone help. Thanks.
the user to use any 3 of the combo's. For example : Combo box 1 "Part Name";
box 2 "Part No." ; box 3 "Supplier".
If the user selects box 2 "Part No." I want the other 2 boxes to synchronize
to show the Part Name and supplier for that Part No. If he selects 1 "Part
Name" the other 2 should show the relative Part No. and Supplier etc..
I can update text boxes with no problem but I can't find an easy to
understand way of doing Combo Boxes. I am sure this must be a common problem
but I haven't found the answer anywhere. I am using Access 2002.
Can anyone help. Thanks.