How do I populate a text box with the caption from the parent form? 1

[djayam]

Hi all,

I have searched amongst the posts but cannot find an answer.

I have a form "frm_Header" which I nest in all main forms so that I only have to make changes to it once. I want a text-box within frm_Header to display the Caption value from its parent form but just can't get the syntax correct!

=[Forms]![frm_Login].[Caption] works fine (The parent form in this case is frm_Login). How do I get it to display the Caption value from whatever the parent form is?

Thanks in advance,

Jason

 

[Remou]

You can use Caption by itself:

=[caption]

 

[djayam]

Thanks for your response Remou, but that just gives the caption of frm_Header. I need the text-box (in frm_Header) to display the caption for the form it is nested inside (e.g. frm_Login)

Does that make sense?

Cheers,

Jason

 

[Remou]

Ok.

=[Parent].[Caption]

 

[djayam]

Knew it would be simple.

Many thanks Remou...