There is a field [CreatedBy] and currently it is filled in once an entry is made in the first field of the form. This code is being used in another form and it works. However, on this form and another, I keep getting a compile error of "Method or Data Member Not Found". Debug goes directly to [CreatedBy].Locked = False
All I am tring to say is that once the first field is filled in the CreatedBy and CreatedDate should fill in and then be locked so that if someone goes in and changes the first field, the creation data will stay the same. There are a ModifiedBy and ModifiedDate that keeps track of last time changed. Any suggestions???
Private Sub Text72_AfterUpdate()
' Once again to lock the "created by" and "when" fields
If IsNull(Me![CreatedBy]) Then
[CreatedBy].Locked = False
Else
[CreatedBy].Locked = True
End If
End Sub
Thank you for any and all help,
PBrown
All I am tring to say is that once the first field is filled in the CreatedBy and CreatedDate should fill in and then be locked so that if someone goes in and changes the first field, the creation data will stay the same. There are a ModifiedBy and ModifiedDate that keeps track of last time changed. Any suggestions???
Private Sub Text72_AfterUpdate()
' Once again to lock the "created by" and "when" fields
If IsNull(Me![CreatedBy]) Then
[CreatedBy].Locked = False
Else
[CreatedBy].Locked = True
End If
End Sub
Thank you for any and all help,
PBrown