the problem I'm having is that it doesn't seem to be comparing the Passcode and DocControlPassword.

... "EmployeeName='" & Me.DocControlPassword & "'" ....
Looking at that line of code, the cause of problem is pretty obvious, isn't it?