switch field to non-edit after initial entry in that field

[valmatic]

Hi. Does anyone know of a way to make an entry field non-editable after the initial entry into that field?

I have a standard date entry field on an access form that, through some code, measures on-time status of a project and reports the status accordingly. A few of my users are changing the date to cover their butts, rendering my reporting useless Any help in protecting my data would be greatly appreciated.

I should mention I'm a complete noob in both Access and VBA programming - but I'm learning

thanks...
Josh

 

[PHV]

Have a look at the Current event and NewRecord property of the Form object and at the Locked/Enabled properties of the TextBox object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ssatech]

Try the After Update event of your entry field:

Private Sub NameOfEntryField_AfterUpdate()

Me.NameOfEntryField.Locked = True

End Sub

 

[Zion7]

ssatech, unfortunately, when navigating to the next record,
whether "NameOfEntryField" is populated or not,
it will be locked.

As PHV said, OnCurrent is the most appropriate.
for examble

Form_Current()
Me.txtDate.Locked = Not IsNull(txtDate)
End Sub