Label name referring to subform (1 Viewer)

[NNothard]

Just a quick question, I can't seem to get this right (as usual )

I have a form and I want the label in the header to display the text from a field in a related subform. I have tried the following syntax to no avail:
=[Forms]![sfrmCompanyName]![LastName]

Any suggestions

Thanks in advance

Nicolas

 

[Pat Hartman]

It doesn't usually make any sense to reference the rows of a subform from the mainform since all you can reference directly is the current record of the subform. But, the syntax when used as a ControlSource is:

=[Forms]![mainformname]![sfrmCompanyName].Form![LastName]

From VBA, you could use the shorter syntax:
Me.sfrmCompanyName.Form!LastName

 

[NNothard]

Thank-you very much, that worked first time.