Move Selected Combo Box Value to Form Field and Then Delete Value From Combo Box Source

[Tomfernandez1]

Hi,

On my Employee Profile Form is field "EmpID" which the user enters the employee ID (unique value assigned when hired). the employee ID numbers numbers go as high as 400 (we currently have 200 employees). We now have temporary employees so I wanted to create a combo box with values from table TA_TempID, ranging from 8001 to 8999, so when the user selects a value from the combo box I want that value to populate in the EmpID field and delete from the TA_TempID table. I can set up the TA_TempID table, and corresponding combo box on the Employee Profile Form but I don't know a code to execute the desired action. I am familiar with VBA and Macros so any direction is greatly appreciated!

Thank you.

Tommy

[pbaldy]

An argument could probably be made for having a single table with a field to signify temporary vs permanent. That said, you can append the temporary record to the regular table with an append query or a recordset, either method using the combo for a criteria. Then use the same criteria to delete from the temporary table. Another case could be made for not deleting the record, just marking it so with a field for status or whatever.

[Tomfernandez1]

"you can append the temporary record to the regular table with an append query or a recordset, either method using the combo for a criteria. Then use the same criteria to delete from the temporary table."

I will give this one a try. Thank you!

Tommy

[pbaldy]

No problem, post back if you get stuck.