Lock and unlock records

  • Thread starter Thread starter news.microsoft.com
  • Start date Start date
N

news.microsoft.com

Hello,
I have a form that accesses a table.
On the form is a Yes/No checkbox (from the table).
I want to be able to lock all the other fields in the record (or just
lock the whole record) by clicking the Yes/No checkbox.
What's the best way to go about this?


Thanks beforehand.
 
In the after update of the checkbox add
If me.checkboxname = -1 then
me.allowedits = false
else
me.allow edits = true
end if

If you are using tabs and subforms more coding is required
 
Back
Top