How do I get a report to take the title of its underlying query?

[jonesey]

Hi, needless to say I am a novice at this, sorry!

The problem is I have a report that is of a standard
format and I choose from a bunch of queries as the Record
Source.

To clarify I can run the same report but choosing from
queries (for example) "qryDaily," "qryMonthly,"
and "qryAnnual" as the Record Source in Properties. Right
now I have to manually change the title in a text field.

How do I get the report to automatically adopt the current
query name as its title? (DOes this question make enough
sense?)

 

[Joan Wild]

Another alternative is to change the Label to a textbox and set its control
source to
=RecordSource

That's assuming you are referring to a label in the report header as the
'title'

If you mean the title bar text then in the OnOpen event for the report, you
could use
Me.Caption = Me.RecordSource

 

[John Vinson]

Another alternative is to change the Label to a textbox and set its control
source to
=RecordSource

Boiinnnnnggg!!!

Cool, Joan - never knew that.