Locking Forms

[Michael]

Is there a way to lock a form when a certain field is
filled in and/or a certain box is checked? I want it so
that the form is not able to be updated again, but it is
able to be deleted. Any help would be great!

I am using Access 2002.

Michael

 

[Lynn Trapp]

On the current event of your form put something like the following:

If Not IsNull(Me.txtYourTextBox) Then
Me.txtYourTextBox.Enabled = False
Else
Me.txtYourTextBox.Enabled = True
End If

 

[Sandra Daigle]

Answered in
microsoft.public.access.formscoding

Please do not mulipost. If you feel you need to post to more than one group
please cross-post (send the one message to all groups at once), rather than
multi-post (send individual messages to each group). In this way, all
responses to your post will be available together, regardless of what group
the responder was in, and the rest of us won't have to read your post
multiple times.

See http://www.mvps.org/access/netiquette.htm for more information.

 

[Lynn Trapp]

Follow the code Sandra Daigle gave you in m.p.a.formscoding. I misread your
original post and my suggestion only locks one field. Hers will look the
entire form.