Locking individual records in a form

  • Thread starter Thread starter Kevin
  • Start date Start date
K

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