Filter data by current user

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that I use to track my employees attendance. I have set up
a workgroups so they have to sign in using there login. What I would like to
do if possible is have the forms they use filter by the current user. If this
is possible how would I accomplish this task?
Thanks in Advance
 
In the query upon which your form is based, just put the following under the
field where the employee's userid is entered in the record...


= CurrentUser()




Hope that helps,
Rick B
 
Thanks, Rick

Rick B said:
In the query upon which your form is based, just put the following under the
field where the employee's userid is entered in the record...


= CurrentUser()




Hope that helps,
Rick B
Click to expand...
 
Back
Top