I am trying to remove a value from a Combo box once the value has been selected
I have a form with a combo box that uses the following sql for the row source
Expand|Select|Wrap|Line Numbers
- SELECT EmpTable.EmpNo, EmpTable.Surname, EmpTable.Forename
- FROM EmpTable
- ORDER BY EmpTable.Surname;
This is then displayed in a data sheet sub form on the original form via a query on the TransTable. Then the prosess starts again only now I don’t want the EmpNo that is in the TransTable to appear in the combo box.
So I should just be able to add something in the criteria of the query above so it does not show rows were the EmpNo exists in the TransTable. This seem like it should be easy but I can’t seem to get it to work!
Can anyone point me in the right direction please?