Even when rst!employee_id is null the code doesn't run through the msgbox and the exit sub statement. Any suggestions are appreciated.

If rst!EMPLOYEE_ID = Null Then

MsgBox rst!Name & " is currently assigned to " & rst!POS & ". " & rst!Name & " needs to be removed from this mpcn before this action can continue.", vbCritical + vbOKOnly

Exit Sub

End If