Solved Reference to another subform (1 Viewer)

[FuzMic]

Hi members
I have a main form with number of subforms separated by tab control.
Lets say there is field T1 in SubFrm1 & in subFrm2 there is field FldNew. i want to place T1 in FldNew. What is its field value.
EASY but I don't know. PLEASE!

 

[theDBguy]

Have you tried maybe something like?

Forms!MainFormName.Subform2Name.Form!FldNew= Forms!MainFormName.Subform1Name.Form!T1

 

[FuzMic]

Will try thereon. THANKS

 

[theDBguy]

Will try thereon. THANKS

You're welcome. Let us know how it goes.

 

[Micron]

I have a main form with number of subforms separated by tab control.

This could prove interesting. I interpreted that to mean that
a main form has a subform control
that subform control has a tab control
two or more pages of the tab control each contains a form

That is a different animal indeed.

 

[FuzMic]

Micron ..the tabCtrl is in the main form. Each page of the tab has one subform

 

[FuzMic]

DBguy

I use instead at target field ControlSource

=Forms!MainfrmName!sourceSubfrmControlName!fieldName

It reflect source field value. Cheerio

 

[arnelgp]

if you are referring within Same main form:

[subform1].control = [subform2].control

 

[theDBguy]

DBguy

I use instead at target field ControlSource

=Forms!MainfrmName!sourceSubfrmControlName!fieldName

It reflect source field value. Cheerio

Congrats! Good luck with your project.