Locking individual records in a form

[Kevin]

I have a form that pulls multiple records from a table.
What I need, is to add a check box to the records that,
when checked, will lock the other fields in the record to
make them uneditable. Everything I have tried so far, has
locked out all of the records instead of the individual
record I am trying to target. In other words, a check on
any record, locks all the records on the form.

 

[Rick B]

If your form is not continuous, then this should work fine. Add the code to
your OnCurrent event so that each time you move to a new record the code
looks at your checkbox and then changes the atributes of the fields you
don't wish the user to modify.

I have a similar setup and it works great.

Rick B


I have a form that pulls multiple records from a table.
What I need, is to add a check box to the records that,
when checked, will lock the other fields in the record to
make them uneditable. Everything I have tried so far, has
locked out all of the records instead of the individual
record I am trying to target. In other words, a check on
any record, locks all the records on the form.