Filter by User?

  • Thread starter Thread starter Oli
  • Start date Start date
O

Oli

Hi

I have several users of a split database - which is stored on a remote
server. Now we have identified the need to not let all users get to each
others data.

Is it possible upon opening a form to filter such that each user can only
see data that they have added? and... if an admin user then all records
viewed?

Many thanks in advance
Oli
 
Yes, this is quite easy to do. If you do store the person who added a record
as part of the record info, then you could easily insert a filter in the
onLoad event of the form and make a check on who the current user is by the
currentUser() function..

Releveant commands:

docmd.applyfilter
currentuser()
 
Back
Top