Covert a single record to read-only?

[WinDancer]

My customer is asking for the ability to convert individual records to read-only when the closed date is added to a form.

They are concerned about changes being made later. There are several hundred records in their application right now and this number will continue to grow.

A little guidance, please?

Thanks,
Dave

 

[pbaldy]

In the current event of the form (air code warning):

If IsDate(Me.ClosedDate) Then
  Me.AllowEdits = False
Else
  Me.AllowEdits = True
End If

 

[WinDancer]

Thanks, Paul

 

[HiTechCoach]

another option to write the same code that Paul suggested:

  Me.AllowEdits = Not IsDate(Me.ClosedDate)