Hi all merry Christmas to you all
I have a combobox on a main form called Employee it uses a table called
tblEmployee
Employee_ID auto number
First name Text
Last name Text
Phone number Text
Inactive yes/no
On the form when you select a name it places in the field Emplee_ID on the main table all works well until we had staff turnover. I then changed the combo box query criteria to filter just the active staff which worked fine until I went back to previous records of the person who had left and found the field blank when I take the filter off they are there. The other strange thing is in the main table the employee_ID field which is of the number type has been accepting text and because it has a lot of record and it won't let me. The main table also has a auto number field Trans_ID that is used as a primary key. I have tried many things in the properties of the combobox but dont seem to be able to arrive a solution.
Any idea's would be welome
Thanks Bob Wild
I have a combobox on a main form called Employee it uses a table called
tblEmployee
Employee_ID auto number
First name Text
Last name Text
Phone number Text
Inactive yes/no
On the form when you select a name it places in the field Emplee_ID on the main table all works well until we had staff turnover. I then changed the combo box query criteria to filter just the active staff which worked fine until I went back to previous records of the person who had left and found the field blank when I take the filter off they are there. The other strange thing is in the main table the employee_ID field which is of the number type has been accepting text and because it has a lot of record and it won't let me. The main table also has a auto number field Trans_ID that is used as a primary key. I have tried many things in the properties of the combobox but dont seem to be able to arrive a solution.
Any idea's would be welome
Thanks Bob Wild