Combobox values changes when another combobox value is selected

Hi Everyone,

I have a simple form with 4 combobox's

Name.......

Reason for lateness...........

Managers Name.............

Managers Email..............

Date and time picker..............

The managers name is linked to the Managers Email

So when the managers name is picked it populates the Managers email field.

But when I select the managers name, the Name and Reason for lateness combobox's reset to first entry in the list.

The datasource is the same for all combobox's just different tables for each box.

I am using SQL for the data.

I am guessing it is something to do with the data source but not sure.

Any help is appreciated.

Quote:

---

The datasource is the same for all combobox's just different tables for each box.

---

Not sure that makes sense. If the data source is the same, then it is not different table.

Anyway, for each combo box, copy the data table and using the new table as the data source.

This was just discussed a few days ago here http://www.vbforums.com/showthread.p...combobox-entry

Quote:

---

Originally Posted by coyney22

Hi Everyone

---

Can you post the code? I think I have encounter it this past few days.