Add, Edit Records in a table

[David Tunstall]

Please help,

I have a look up table with 20 values. I want to allow
users to open the table to add new records but not be able
to edit the first 20 that are already in the table. They
also need to be able to edit any records that they add
themselves after the first 20.

Hope this makes sense.

Thanks
David

 

[Jeff Boyce]

David

One approach might be to add a field that you set on the "20" and use to
prevent editing via code behind your form. You ARE using a form for this,
right?! If you let users get at the tables, I suspect your only other
option is to get into the very time-consuming use of the Access security.