Using a form to record the UserID of the person who entered a record

[Demerit]

Greetings to all;

Here below is a Security DB I downloaded and i intend to use it in my DB. In this DB, I have included a table named "TblCustomer" with fields (customerID, FName, LName, DateOfEntry, and SecurityID) and I have also included a form named "FrmCustomer" with controls same as in the table.

On the Event Click of the "Validate" button, i wish to attach a VBA which saves the data I enter but for SecurityId, it should be that of the person who is currently loged in. How can I go about that.

Thanks in advance



Demerit.zip

[rpeare]

There's something wrong with your zip file. Try it again.

[Demerit]

thanks to everyone I have been able to solve this problem