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

  • Thread starter Thread starter jonesey
  • Start date Start date
J

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?)
 
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
 
Back
Top