OPB, it doesn't work that way either.

Des this help clarify?
ChangeAnalystApproval [EmployeeName] is a combo box from a query.
Find the [EmployeeName] in the [tbl_Employees] and retrieve the [Passcode]
Then the [frm_MCOs]![DocControlPassword] must equal [tbl_Employees]![Passcode]If Password is blank, display msgbox1
If Passcode and DocControlPassword match, display the msgbox2
If Passcode doesn’t match DocControlPassword, display msgbox3