Allow Edits query

[VeeFour]

How do I turn off Allow edits once data has been entered into a field so no more editing is possible?

 

[GKProgrammer]

You could set the controls enabled property to false Regards,
gkprogrammer

 

[saltecho]

In the AfterUpdate event of the control containing the field which is your switch add the following:

Me.AllowEdits = False

This will turn off editing for the current form.

if you want to just turn off that field then you have to move the focus to another control then lock the first control

Me!nextcontrol.SetFocus
Me!firstcontrol.Locked = True

You might need to test the value because the first control will stay locked so:
In the Form_Current event

If Not IsNull(Me!firstcontrol) Then
Me!nextcontrol.SetFocus
Me!firstcontrol.Locked = True
Else
Me!firstcontrol.Locked = False
End If

Now if the control is empty when you open a new record you will be able to edit it. you can't unlock or lock a control whilst it has the focus so you have to move first.

 

[VeeFour]

Exactly what I needed, thx alot