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

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
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
 
Upvote 0
I cannot get this to work...

Can you be more specific on the exact code and where it needs to be entered?
 
Upvote 0

Forum statistics

Threads
1,214,324
Messages
6,118,890
Members
448,854
Latest member
Eduard_Stoo

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
Back
Top