You could do a lookup on the AfterUpdate event of the combobox to see if they are an active employee. If they aren't throw up a message box to say they are no longer active and then blank the combobox value, so that another option has to be selected.
If you can post a copy of your DB i will try...