Auto Selection of ComboBox

[amirbilal]

Let me expalin the scenario.

I have two combo boxes on a form the second one gets updated on any selection change made in the first one i.e. onChange event. lets say first one is Company and the second is employees.

When I select a company 'ABC' the employees names are loaded in second and I make a slection out of it, lets say 'james' is a selection.

Now I select another company e.g. 'XYZ' and select any of its corresponding emloyee and so on.

Now whenever I select any old (in above example 'ABC') selection I made in the company combobox its corresponding eployee names are loaded in the list but the last selection 'james' is automatically selected.

I do not want it to behave it like that. I want that there should not be any auto selection.

Please let me know if there is any way to do it.

Thanks so much for your time.

Best Regards

 

[Bat17]

Assuming that the second box is unbound youshould be able to set its value to ""
Me.MySecondCombo = ""

HTH

Peter