2 ComboBoxes Interacting with each other

[Infused]

I have a user form in which I would like to:

A.Have A ComboBox Display the Account#'s in our data source (making this a Search Tool to update the fields in the form)
B Have A ComboBox Displat the Customers in our data source (making this too a Search tool to update the fields in the Form.)
C Have Either ComboBox Update each other without triggering an foreseeable endless event change loop.


Part C is where I struggle. Is there a work around to this???

Or should I go about achieving this in a different method?

You help is much appreciated.. Thanks in Advance....

Infused

 

[tybaltlives]

Im not sure if you will have an issue. I have a user form with a combo box for employee numbers and one for employee names. If you select the number or the name from either box the userform is updated with the correct information. The only issue I had was that both employee numbers and names needed to be sorted in ascending order. Which was impossible for both boxes at the same time. The sorting allowed the operator to start typing a name or a number and it would appear in the box, rather than using the drop down arrow. I just needed to have a toggle switch that told the operator if the list was sorted by employee number or name.

When either a name or a number is selected the combox "changes" and initiates a subroutine that fills out the user form according to the row in the database corresponding to the individual.