HOWTO: Lock a field in a form based on criteria?? 1

[JesseM3]

I want users to be able to only add a new entry using a form, not edit current ones -- but I still want them to be able to scroll through the current entries. Is there a way I can do this? Some kind of expression that says something like "this field is locked unless blah blah blah" ..

Help!

Thanks.

 

[DanJR]

Have a go with this. This code needs a label on the form called "lblEditMode"...

--------
Private Sub Form_Current()
If Me.NewRecord Then
Me.lblEditMode.Caption = ""
Me.AllowDeletions = True
Me.AllowEdits = True

Else
Me.lblEditMode.Caption = "this field is locked unless blah blah blah"
Me.AllowDeletions = False
Me.AllowEdits = False

End If

End Sub
-----------

Hope this helps
DanJR

 

[JesseM3]

Works perfectly! Thank you so much. You saved me a huge headache.