Locking certain items

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

Guest

I have a form called frmBooking containing a subform in datasheet view called
frmBookingSubform. In frmBookingSubform have a tickbox called booked when
this is ticked it updates tables and perfoms calculations on the data within
its line. I then have a problem of data being changed after the calculations
which would cause problems for me should people wish to cheat the system. I
would like an event that when the box is ticked the columns within the row
are locked without all rows being locked so data within any ticked row cannot
bechanged where others can.
I have created a column which is a unique identifier for each row called
LockRow which is an autonumber. I was hoping that this value could be used to
Lock the columns where the LockRow = LockRow of current row. I would be
extremely pleased for any help regarding this subject
 
Not sure what you mean by LockRow.

Just build oncurrent code that says, if tickbox=true, then...
And then for each control in your row...

Me.somefieldname,locked = true.


If you will do a search, you will find similar (but more detailed) answers.
I'd probably look in the Forms or Formscoding newsgroups. This is a pretty
common question.

Rick B
 
Back
Top