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 ?

 

[DOC666]

Yes they do both to input new records and to update/modify if required

 

[Galaxiom]

You would block or allow edits by setting the "enabled" and; or "locked" properties of each control which has access to the data,

Rather than affect the controls it would be more officient to use the technique Tony describes to change the AllowEdits property of the form.