Record Security setup

[SF]

Hi,

I am new to access security. I have a database setup and running. User do
data entry through forms. I create a popup menu hoping to create a way for
user to click on the Edit (by unlocking the form control), but every user
can edit it,

Is there a (practical) way to only allow the onwer of the record to edit
specific record?

SF

 

[Keith Wilby]

Hi,

I am new to access security. I have a database setup and running. User do
data entry through forms. I create a popup menu hoping to create a way for
user to click on the Edit (by unlocking the form control), but every user
can edit it,

Is there a (practical) way to only allow the onwer of the record to edit
specific record?

SF

Yes. Store the current user's name in the record when it is created and
then use the form's Current event to test the username field and set the
AllowEdits property accordingly.

HTH - Keith.
www.keithwilby.com