How do i protect a record after data entry on a form

[Belinda7237]

I have a form with a lot of data entry fields and the results get stored in a
table. I want to be able to protect the form entry once the user saves the
record and moves on to the next form entry. What is the best way to
accomplish this?

[Arvin Meyer [MVP]]

A bit of code in the form's Current event (untested):

Private Sub Form_Current()
If Me.NewRecord = False Then
Me.AllowEdits = False
Me.AllowDeletions = False
End If
End Sub
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Post by Belinda7237
I have a form with a lot of data entry fields and the results get stored in a
table. I want to be able to protect the form entry once the user saves the
record and moves on to the next form entry. What is the best way to
accomplish this?

[Rinku Singh]

This is Tested Now I Have test it.
Rinku Singh

Post by Arvin Meyer [MVP]
Private Sub Form_Current()
If Me.NewRecord = False Then
Me.AllowEdits = False
Me.AllowDeletions = False
End If
End Sub
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Post by Belinda7237
I have a form with a lot of data entry fields and the results get stored in a
table. I want to be able to protect the form entry once the user saves the
record and moves on to the next form entry. What is the best way to
accomplish this?