Protect record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want protect the record in the Form, because when the people open the form,
then they just overwrite the old record.

How can I protect the record, like they can view the old record, but can't
change it, or if they want to update they should use a command button then
they can make change.

Thanks for your help
 
Private Sub Form_Current()
If Me.NewRecord Then
Me.AllowEdits = True
Else
Me.AllowEdits = False
End If
End Sub

in the command button's click event put:
me.allowedits = true
 
Sorry, I am new in Access, I have no idea where to put those code.

Please direct, thanks a lot
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top