Filter by network user id

D

Deirdre

I have a database where I want to filter the records according to the user's
network id - basically I don't want them to have to log in with a userid and
password to the access db, they are already logged on to the network.
I already have each users network user id tagged to each record. Can I use
Current User()in the filter property of a form, report, and data access page?
And if so, would it be [user]=CurrentUser() on the filter line in the
properties box, or does it require code in vb?
Thanks
 

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

Top