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

[mqarep]

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.

 

[cstlaurent]

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]

I cannot get this to work...

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