Originally Posted by
Access_Novice
...I should not be able to edit this right...
...I can in edit 0001 and change it to, let's say 0005...
......I end up getting a message saying "The record cannot be updated or deleted because table 'tblGymnast' includes related records...
You're not making changes to the Field, you're simply entering data into the Textbox; the Field has only been edited when the Value changes in the Table, and Access is not allowing that.
If you want to prevent the user from even typing into the Textbox, if it is already populated, you can use code like this:
Code:
Private Sub Form_Current()
If Nz(Me.accountNo, "") <> "" Then
Me.accountNo.Locked = True
Else
Me.accountNo.Locked = False
End If
End Sub
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007