If a chkbx is check can not edit another field

[Joe8915]

Belive it or not, I never had to do this before. Sounds simple enough.

What Im trying to acomplish is, if this box is check, you can edit another field in the same form.

Just what is the best way of accomplishing this.

Thanks

 

[boblarson]

In the form's On Current event you use

If Not Me.NewRecord Then
   Me.AllowEdits = Me.YourCheckboxNameHere
End If

And then in the After Update event of the checkbox you put the same.