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.
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

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?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,114
Messages
5,570,269
Members
412,315
Latest member
ikokidko
Top