How to lock separate entries

[jpnyc]

I'm new to access and trying to create a database. What I would like to do
is to have a button/check box (basically something to click/unclick on a
form) to prevent/correct the editing of all the entered data for each entry.

I created a table and form. Say I have fields A-G on the form and I have
1-4 participants(entries). Each time I click on the( l>*) to make a new entry
participants numerically increase of course.

i.e.
A B C D E F G
1 * * * * * * *
2 * * * *
3 * * *
4

So now I want to lock/unlock each entry individually(1)(2)(3) on a form so
the data won't change.

Say I want to return to participant 2 and add to field (B), is there a way
to only unlock 2 so that I do not mess-up 1 or 3's data by accident (since it
is locked). This would also allow me to create 4's information without
distorting 3's data since I previously locked it and not worry about
overwriting another field of data.

Ideally I need to keep entering data, locking each patients information and
moving to the next. When I find an error, I can easily return to their form,
click unlock and make the correction.

Repetative, I know... sorry....but this function would make my day so much
better.

Again, NOVICE here, so go easy please.

Many Thanks
John Patrick

 

[PieterLinden via AccessMonster.com]

If I understand you right, you could set the AllowEdits property of the form
to False in the OnCurrent event (so every time you move to a different record,
it's automatically locked). Then you could have a button on your form to
unlock it.

 

[jpnyc]

I think that would work well, but I run into a few problems.

1. I'm running Access 2000 so I don't think I have the OnCurrent event
option.
2. After I place the button, I don't know how to create the command to
unlock it.

Thanks