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.
Re: Combobox values changes when another combobox value is selected
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.
Re: Combobox values changes when another combobox value is selected
Re: Combobox values changes when another combobox value is selected
Quote:
Originally Posted by
coyney22
Hi Everyone
Can you post the code? I think I have encounter it this past few days.