Locking records individually - Newbie needs help

  • Thread starter Thread starter Me
  • Start date Start date
M

Me

I have created a table & the associated form to allow
users to enter data.

They need to be able to scroll through the records and
make changes / update when necessary, until the point
where that specific record is final - they then need to
lock only that particular record from being edited /
updated and not any others.

Is this possible?
 
Me said:
They need to be able to scroll through the records and
make changes / update when necessary, until the point
where that specific record is final - they then need to
lock only that particular record from being edited /
updated and not any others.
Click to expand...

Will the user decide when to lock the record?

If so, you could add a Yes/No field to your table (I'll call it Final), and
add a checkbox control to your form bound to this field. In the OnCurrent
event for the form
If Me!Final = True Then
Me.AllowEdits = False
Else
Me.AllowEdits = True
End If
 
Back
Top