Howdy Pros from Dover,
I have a login form with a combobox which derives its list of values from an EmployeeRecord table (i.e., last name, first name, securityID, job grade and record number): only the last name and first name appear in the list. (I swiped some VB code for a multiuser login form and routine from several previous posts.) After it performs the security validation/authorization, it then opens a navigation control form based upon the user's job grade. It runs after the click button event. To this I would like to update another table, LoginEvent, with the last name, first name and record number from the combobox selection, and also add the time and date of the click.
So, this is my first Access DB, and I am swimming, perhaps drowning, trying to figure this out, referencing Step by Step Access 2010, Access 2010 Inside Out, and Acess Inside Out VBA Programming. Any suggestions on options to accomplish this?