User Security

[muralikreddy]

Hi,

I have a table which will be accessed and updated by various users, with the help of a form. I want to provide an option where the user can modify data keyed by him in the table through the form and he can only view the data entered by other users. In this table I'm capturing the userid when the data is updated.

Please help me how will i be able to put this control.

Thanks & Regards,

Murali

 

[llkhoutx]

What you want to do is frought with issues. However, at it's simplest, on the before up date event of each data control check to see is that controlled is "controlled" by another, if not update, if so, cancel. This "controlled by" could be a hidden control on the same form which a similar name to that being controlled.