G
Guest
Below, I have pasted some code that I have been using to hid fields dependent
on entries in other fields.
This works. Except in this case, the passexpiration field as well as the
passport checkbox are on a tab within a form. I am not sure if I should
handle the "me" expression to indicate a subform or tab - and in either case,
I do not know what syntax to use to achieve that.
Thanks,
Private Sub Form_Current()
Me.PassExpiration.Visible = False
Select Case Passport
Case Is = "-1"
'checked box has a value of -1
Me.PassExpiration.Visible = True
Case Else
End Select
End Sub
on entries in other fields.
This works. Except in this case, the passexpiration field as well as the
passport checkbox are on a tab within a form. I am not sure if I should
handle the "me" expression to indicate a subform or tab - and in either case,
I do not know what syntax to use to achieve that.
Thanks,
Private Sub Form_Current()
Me.PassExpiration.Visible = False
Select Case Passport
Case Is = "-1"
'checked box has a value of -1
Me.PassExpiration.Visible = True
Case Else
End Select
End Sub