Reference Subform name in Nav form Header (1 Viewer)

theDBguy said:

Hi. Give this a try and let us know how it goes.

Code:Copy to clipboard

=[NavigationSubform].[SourceObject]

Click to expand...

xyba said:

Hi. Tried it but it returns #Name? error.

Click to expand...

theDBguy said:

#Name? usually refers to a typo. Double-check the name for the subform control and try it again. The syntax I gave you works for me.

Click to expand...

xyba said:

Hi, sorry but I don't understand. Was I supposed to simply copy and paste your code or did it need changing for my circumstances? Also, when you say 'Double-check the name for the subform control' check it where?

Apologies if I sound dumb.

Click to expand...

theDBguy said:

Hi. Not sure if the following images would help you, but this is what my test form looks like using the syntax I posted earlier.

Click to expand...

xyba said:

I compared my nav form with yours and couldn't see any difference then, suddenly, mine worked. Strange.

Thanks for your help.

Click to expand...