referring to object on a subform or tab

[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

 

[Guest]

The Me indicate the current form where this code is located in, so the me
will be followed by the name of the object within that form.
In the TAB case, you refer to any field in it like it was on the form itself
and not like its on a sub form

Me.[FieldName on the Tab]

Unless there is a sub form on the TAB, in that case
Me.[SubFormControlName].Form![FieldNameInTheSubForm]

 

[Guest]

That is what I have. passexpiration is the object name - and it doesn't like
it.

The Me indicate the current form where this code is located in, so the me
will be followed by the name of the object within that form.
In the TAB case, you refer to any field in it like it was on the form itself
and not like its on a sub form

Me.[FieldName on the Tab]

Unless there is a sub form on the TAB, in that case
Me.[SubFormControlName].Form![FieldNameInTheSubForm]

--
Good Luck
BS"D

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

 

[Guest]

Okay - I finally got it! Thanks Ofer!

The Me indicate the current form where this code is located in, so the me
will be followed by the name of the object within that form.
In the TAB case, you refer to any field in it like it was on the form itself
and not like its on a sub form

Me.[FieldName on the Tab]

Unless there is a sub form on the TAB, in that case
Me.[SubFormControlName].Form![FieldNameInTheSubForm]

--
Good Luck
BS"D

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