Locking Rows

M

Mike

Hi,
I have a form containing a subform which is viewable in datasheet view. The
subform contains a tickbox which performs several tasks but i would like it
to be able to Lock the line of values that it is on to stop them being
changed once it is clicked without locking the next line on the datasheet.
I know how to set the lock property and can uniquely identify each line as
each is given an autonumber value but the trouble i'm having is the main
structure of the code like a
Do (Value1.Locked = true Value2.Locked = true) where ID = ID.
Many thanks for your time
 
Top