Filter by User?

[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

 

[Kailash Kalyani]

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()