Background - I am new to MSAccess and have no background in VB code.
I have table "tbl_Employee" which contains a persons initials and PIN (password) and a form that contains ticket information .
I have a form (TEST_LOGIN) that the user enters information about a ticket then enters his initials.
A pop-up Modal form (TEST_POPUP) prompts them for a PIN (password). When the user clicks "OK", I have the "On-Click" event run the Macro that is included in the code section below.
Are my references ok for the forms? Am I able to pass this infromation from my forms to the DLookup command?
Thanks - Kevin
I created a macro that is attached to the "OK" button of the
DLookUp("[EmpPIN]","[tbl_Employee]","[EmpInitials]='" & [Forms]![TEST_LOGIN]![CR_TECH] & "'")="'" & [Forms]![TEST_POPUP]![T_EmpPIN] & "'"