Add, Edit Records in a table

  • Thread starter Thread starter David Tunstall
  • Start date Start date
D

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
 
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.
 
Back
Top