Hi,
There have been plenty of threads on having a field unlock after another field has been updated. I have 5 sets of an option group and text box. I want the option group locked/disabled when the text box is empty. Maybe one might sufficient. Here is the code I'm using in both in AfterUpdate and OnCurrent:
If IsNull(Me.Text83) Or Me.Text83 = "" Then
Me.Frame188.Enabled = False
Me.Frame188.Locked = True
Else
Me.Frame188.Enabled = True
Me.Frame188.Locked = False
End If
My question is: How can do this for the other 4 sets? Do I have put this code in both places for each locking set or is their a shorter way?
Thanks so much!
There have been plenty of threads on having a field unlock after another field has been updated. I have 5 sets of an option group and text box. I want the option group locked/disabled when the text box is empty. Maybe one might sufficient. Here is the code I'm using in both in AfterUpdate and OnCurrent:
If IsNull(Me.Text83) Or Me.Text83 = "" Then
Me.Frame188.Enabled = False
Me.Frame188.Locked = True
Else
Me.Frame188.Enabled = True
Me.Frame188.Locked = False
End If
My question is: How can do this for the other 4 sets? Do I have put this code in both places for each locking set or is their a shorter way?
Thanks so much!