Lock individual records after saving

[DOC666]

Any help appreciated

I have 4 users all with the same rights
what i want to do is lock each individual record created by each user from the other 3 users after they have been saved ( I am not referring to record locking/table locking while updating/creating ). ie They can all read each others created records BUT only update/modify their own created records.


They all have individual passwords to log in.


Any suggestions ?

[orange]

How do you identify which record belongs to which user?
Only allow update/edit if user = owner.

[ranman256]

Add a field USER, and update behind the scene. Then only that user can edit.
The internal function: CurrentUser()

[June7]

Open form(s) filtered to only that user's records. Requires a field in record for 'owner'.

Otherwise, will need validation code in record or form BeforeUpdate event. Or lock/unlock form for editing as user moves record to record.