Does anyone know how to create a login form that will only keep a record of the person that logs in if they enter data in a form.
So the steps are like this:
1. Clerk logs in with name and password.
2. Directed to data entry form.
3. Clerk types in data.
4. Clerk prints form for customer. (right after clerk prints form, it saves the record in database table)
The data saved into the database table is what the clerk filled out in the form and also his/her name from when they logged in, date, and time of when they printed the form so we know who logged in to create the record and print it for the customer.
The date and time is not mandatory but would be a nice feature to have.
I know nothing of VBA scripting and would need something that I can just edit to fit my scenario if possible.
Thank you very much in advance.