I have a continuous sub form with 10-12 fields on. I have added checkboxes to the top of the form to say that if the checkbox is ticked the field becomes enabled. This works fine when there is no data in any of the fields. You tick the check box, the field becomes enabled and you can tab down filling in the data for all users.
However if you later go in to add figures to a different field and tick the check box to enable that field it will tab to the previously completed field because there is data in it.
Sorry if this is hard to understand. Is there anything that I can add to this code so it only goes to the enabled field and not any other field that may have data in?
Private Sub Check_Absence_AfterUpdate()
If Me!Check_Absence = True Then
Me!Absence_Score.Enabled = True
Me!Absence_Score.Enabled = False