I used the following code and It locked my field, but for whole subform, not each record. How would I go about doing this.
If IsNull(Me.Tab1.Value) Then
Me.StartTimeChallengeYes.Locked = True
Me.StartTimeChallengeNo.Locked = True
Else
Me.StartTimeChallengeYes.Locked = False
Me.StartTimeChallengeNo.Locked = False
End If
If IsNull(Me.Tab2.Value) Then
Me.ActivityChallengeYes.Locked = True
Me.ActivityChallengeNo.Locked = True
Else
Me.ActivityChallengeYes.Locked = False
Me.ActivityChallengeNo.Locked = False
End If
Me.StartTimeChallengeYes.Locked = True
Me.StartTimeChallengeNo.Locked = True
Else
Me.StartTimeChallengeYes.Locked = False
Me.StartTimeChallengeNo.Locked = False
End If
If IsNull(Me.Tab2.Value) Then
Me.ActivityChallengeYes.Locked = True
Me.ActivityChallengeNo.Locked = True
Else
Me.ActivityChallengeYes.Locked = False
Me.ActivityChallengeNo.Locked = False
End If