locking records

[mickelingon]

locking records (legal purpose)

Hi

I'm making a journal and will be able to lock records (legal purpose) when pushing a button.
Just like signing.
But I will be able to add a new record when treating the patient the next time.

Thanks

Mikael

 

[boblarson]

You can set the Allow Edits to NO and the Allow Additions to YES.

In the form's On Current event, you can use

If IsNull(Me!YourFieldNameHere) Then
   AllowEdits = True
Else
   AllowEdits = False
End If

 

[mickelingon]

Thanks Bob

Can you use the code with a button that says "sign" and it will aply this?
Do I just create one and use this in the code builder?
If IsNull(Me!YourFieldNameHere) Then
AllowEdits = True
Else
AllowEdits = False
End If

 

[mickelingon]

I tried it with a button, but then it locks it for editing with a new post as well

 

[mickelingon]

Ok, I have multiple posts that I want to protect with this code

Private Sub Form_Current()
If IsNull(Me.Debut) Then
Me.Debut.Locked = False
Else
Me.Debut.Locked = True
End If
End Sub

How do I do THAT?