MS Access - Setting a Report Header label value

I have a report that is based on a Query.  I have a separate table that contains the Page header labels I want to use.  How can I query the separate table (not related to the content of the report) to set the Caption value of the label?
Who is Participating?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
Use DLookup() as the Control Source for a textbox (instead of label):


Rey Obrero (Capricorn1)Commented:
how are the label information stored in the table? does it have id to distinguish them from each other?

post sample data...

you can create a function to get the correct label,
by passing a parameter to the function
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.