Turning AllowEdits to false for individual fields within a form/sub-form

[kate2272]

Hi Guys

I was wondering if it is possible to turn AllowEdits to false after data has been entered for individual fields within a form/sub-form. I've found that I can do this in the 'AfterUpDate' by assigning Me.AllowEdits = False .... BUT this then doesn't allow me to update data in other fields within that form/sub-form after it has been saved ... it seems to assign this property all the other fields within the form/sub-form ...

Any assistance would be greatly appreciated.

Cheers
Kate

[missinglinq]

You can Lock the individual fields. IF you only want to lock the field after the record is saved, use

Private Sub Form_Current()
If IsNull(Me.YourTargetField) Then
  YourTargetField.Locked = False
 Else
  YourTargetField.Locked = True
 End If
End Sub

If you want to lock the field as soon as data is entered and the user tabs out of the field, use the above code and add this:

Private Sub YourTargetField_AfterUpdate()
If IsNull(Me.YourTargetField) Then
  YourTargetField.Locked = False
 Else
  YourTargetField.Locked = True
 End If
End Sub

I have to warn you, as I do with everyone doing this kind of thing, you need to have some strategy in place for editing the field if it becomes necessary, as it almost always does!

Linq ;0)>

[kate2272]

Thank you Linq

Hi Linq,
Thanks heaps for your help. The fields in question are defaulted to automatically display date and time of commencement of the record ... therefore, it is important that these fields aren't altered after the record has been saved, so the record can be accurately monitored for efficiency for completion.
Thank you once again.
Kind regards
Kate

[missinglinq]

Glad we could help, Kate!

Linq ;0)>