Edit specific field records only

[syedadnan]

I want to control the edits of form like if the fields in form are Area, Location, Country, Map, Landline

I want to stop edits on Map and Locations fields once saved yes but user can change rest fields

 

[omnibaer]

Private Sub Form_Current()
On Error Resume Next
Me!Map.Locked = (Nz(Me!Map, "") <> "")
Me!Locations.Locked = (Nz(Me!Locations, "") <> "")
End Sub

Always make sure you validate your fields when using them in functions (what Nz is for), or null errors may result.

Cheers