Can you access the security user signons using a query?

B

Bunky

I have an application that the user must enter their specific code into every
record they touch. Is there a way for me to program the application to look
at the security data and pull that information into a regular form?
 
J

jacksonmacd

The CurrentUser() function will return the name of the Access login
that is currently active. In your editing form, you can use the
BeforeUpdate event to capture the value of CurrentUser(), and stuff it
into a field of your choosing.
 
B

Bunky

Thanks a bunch! I'll try it!!!

jacksonmacd said:
The CurrentUser() function will return the name of the Access login
that is currently active. In your editing form, you can use the
BeforeUpdate event to capture the value of CurrentUser(), and stuff it
into a field of your choosing.
Click to expand...
 
Top