Access 2000 - Locking fields for editing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form which has several fields onit, once a user has completed the
fields (some are drop downs some text) and saved that record, i dont want the
users to be able to change the fields on that screen, I want them tobe locked
after they have input them, does anyone know how to do this.

Following on from this I want another form (basically a copy of the first
one where editing and changes can be made but want to limit access to this
form to certain admin users is this possible.

Thanks
 
All of this has been addressed many times in the newsgroups. Please read
the previous posts on the topic. Look for "locking fields".

In my opinion, there is no need for a separate form, just apply your locks
based on the user level. If the user is an Admin, let them make changes.
If not, lock the fields for existing records.

In the future, I'd suggest you search for your answers before posting a new
thread. The easiest way I have found is to go to www.google.com, click the
"groups" option, and enter a search string similar to the following...

microsoft.public.access lock field

or

microsoft.public.access secure field
 
Apologies for wasting your time Rick B

But not been an Access 2000 expert I am also not a newsgroup expert, but I
will endevour to find out for myself before posting again.
 
Back
Top