Two combo boxes used to select data in form but independent.

mqarep

Board Regular
Joined
Mar 12, 2002
Messages
91
I have "Supplier" and "Supplier Number" combo boxes. Data in my form is displayed based on which on my user chooses. However, my users are confused because the two combo boxes are indepenent from each other.

In other words, when a user makes/enters a selection in the "Supplier Number" combo box to display the associated data, the "Supplier Name" combo box still contains the name from the last time it was used to display data. My users are complaining that this is confusing.

How do I fix this this so that when one combo box is used, that the other displays associated data?
Thanks.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

cstlaurent

Board Regular
Joined
Jan 14, 2005
Messages
182
With the after update event of both field, make them select the value of the other field. I assume the combo box showing the name of the vendor is compose of two colums, where the first one is hidden and contain the vendor ID.



Combo1 after_update
combo1 = combo2

good Luck
 

mqarep

Board Regular
Joined
Mar 12, 2002
Messages
91
I cannot get this to work...

Can you be more specific on the exact code and where it needs to be entered?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,551
Messages
5,838,055
Members
430,527
Latest member
MyFace2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top