Hi. I use a lot of tab strips in my applications and the first time I needed to refer to a value in a subform, in a page, in a tab strip, in a form (you know where I'm getting wuth this?) it was not evident.
The trick is to use fully qualified identifiers. For instance:
Forms!MainFormName!tabObjectName.Pages("pagName"). Controls("sfrmSubformName").Form!ctlControlName
The only object names that do not change here are Forms, Pages and Controls. I suggests you try this in the Immediate Window to see if you can read a value in a field.
Of course if your code is inside that form you can shorten it with:
Me!tabObject.Pages("pagName").Controls("sfrmSubfor mName").Form!ctlControlName
You can be clever and use something like:
Dim sfrm as Access.Form
Set sfrm = Me!tabName.Pages("pagName").Controls("SubformName" ).Form
Then use sfrm!FirstName & " " & sfrm!LastName
This exploring this avenue. Let us know if it helps
Daniel
|
refer to subform values
