I'm loosing my mind now

ok I got two tables one is the EmployeeGL.Table and the other is the Terminations.Table, now both tables have a drop down combo box that has Active or Terminated (termination table has different values in combo box but Terminated is one of them) in it this represents their status. What I want is as soon as the combo box is changed to "Terminated", I want the Termination.Table to updated with that employees information and deleted out of the EmployeeGL.Table. Bare with me cause I'm still new to sql, so I'm still learning how to create stored procedures and triggers.Or perhaps an Append instead of an UPdate Trigger. Cant seem to get this to work...going insane now would like to make this code a trigger or a stored procedure of some kind
Code:
INSERT INTO TERMINATION ( Status, [TM #], LastName, FirstName, SocialSecurityNumber, DateHired, Title )
SELECT ALPHA.STATUS, ALPHA.[TM#], ALPHA.LASTNAME, ALPHA.FIRSTNAME, ALPHA.[SSN#], ALPHA.HIREDATE, ALPHA.JOBTITLE
FROM ALPHA
WHERE (((ALPHA.STATUS)="TERMINATED"));