Prevent user from editing previous subform field

[falcondeer]

Hi everybody,

I was able to prevent user from deleting or editing previous records in my subform by entering the following in "on Current" evnet.

Private Sub Form_Current()
If Me.NewRecord Then
Me.AllowEdits = True
Me.AllowDeletions = True
Else
Me.AllowEdits = False
Me.AllowDeletions = False
End If
End Sub

Now in another subform, I want to prevent user from editing first field filled before and leave the rest of the fields editable for next time and so on.

I put the previous code in the first field "afterupdate" event but it disabled all other fields when coming back to it later.

Thanks

 

[MarkK]

Now in another subform, I want to prevent user from editing first field filled before and leave the rest of the fields editable for next time and so on.

This sounds like a design flaw. "Next time" users should add a new record, not add data to the rest of the fields. As you add data to a table it should get longer, not wider.