Dynamic Subform Title

[Tuckejam]

I have a form that shows the data for each "Chapter" and a subform in that report that shows the "Houses" in that chapter



I would like the caption for the subform report to show

Chapter "__" Houses

with the "__" being what ever chapter the form is currently showing, so if i'm looking at chapter 7 the caption would show
Chapter 7 Houses

somehow linking the subform caption to the Form chapter name property


again I apologize, very new to access so I am still struggling to a bit to even understand how to properly ask questions
Thank you for everyone's help

[moke123]

again I apologize, very new to access so I am still struggling to a bit to even understand how to properly ask questions

Apology accepted, but not really neccessary

A form,subform,report, and subreport are very different things so its a little confusing when you state things like " the subform report"
Being new its OK. Just something to bear in mind.

If I follow you correctly you want to set the caption of the label attached to the subform or subreport control.
To do that you would use something like

Me.Whateverthelabelnameis.Caption = "Chapter " & me.yourChapterNumber & " Houses"

[Tuckejam]

ok question

where do I put that wonderful piece of information? I understand the "whateverthetablenameis" and "yourchapternumber" and have changed those appropriately (it think)

Me.tbl_Houses.Caption = "Chapter" & me.ChapterName & "Houses"

I tried entering that in the caption property of the label but it just shows that full text.

(now Im sure your probably laughing and going to tell me I need to put that into a VBA module somewhere in which case I am going to need more help or just wait until I'm a little further along with my access experience)

Thanks again

[moke123]

I would probably use the OnCurrent event.

heres an example.Hope its what your looking for.

[moke123]

btw, you were close. You need to include the spaces between the quotation marks.

Me.tbl_Houses.Caption = "Chapter" & me.ChapterName & "Houses" would be Chapter7Houses
should be
Me.tbl_Houses.Caption = "Chapter " & me.ChapterName & " Houses" would be Chapter 7 Houses

[Tuckejam]

WOW!!!

That was a considerable amount of work to show me how to do that.
sincerely appreciated!

[moke123]

Glad you got it sorted.
Good luck with your project.