hi, i have a form where i need to capture the name of the person logged in to record that they are responsible for making that entry. i used one of the threads in this forum to make a login form and then use dlookup to capture the name of the user that is currently logged in, which works, but the problem is that this value changes for all entries and forms every time someone different logs in.
how do i freeze the field so that after it captures the name of the person logged in who made that entry, it doesn't change anymore?
This is the code i have so far, as the control source for a text box:
=DLookUp("User","qryCurrentUser")
Hope someone can help, thanks!
how do i freeze the field so that after it captures the name of the person logged in who made that entry, it doesn't change anymore?
This is the code i have so far, as the control source for a text box:
=DLookUp("User","qryCurrentUser")
Hope someone can help, thanks!