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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top