Lock and unlock records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

news.microsoft.com - 17 May 2007 13:13 GMT

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.

Reply to this Message

Eric Blitzer - 17 May 2007 13:57 GMT

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

> Hello,
> I have a form that accesses a table.
[quoted text clipped - 4 lines]
>
> Thanks beforehand.

Reply to this Message