Hi All,

I have this file that has 5 users,i would like to be able to track which user has changed or modified a record as the file contains sensitive data.

I created passwords based on the groups(5)

I then had this set up in a script

set field(user),status(current groups).

The strange thing is in the user field..all the groups are displayed instead of just one group.(nb: each password is a member of just one group)

Where have i gone wrong?

anita

You probably did this with the master password. All master passwords are members of every group.

Also, be sure that you have properly associated each group with its password in the Access Overview screen.

HTH

Old Advance Man

I forgot to mention that i also tried going in with the users passwords but still the field

"user" contained all the groups.

I have also checked in the access previldges overview and each group seems to have its own password.

anita

anita, if you want to track the names of the last user who modified a record, you can set a text field to auto-enter the Modifier Name, which is the name of the user as entered in the application preferences.

FYI, when working with Groups and calculations, instead of a structure like

If(Status(CurrentGroups)="foobar", result1, result2), use something like

If(PatternCount(Status(CurrentGroups), "foobar"), result1, result2)

Thanks the calculations worked miracles!

anita

Better yet, just auto-enter Status(CurrentUserName). It