Text of a RecordSource

[Martin]

Hi,

ich have a Report with a recordsource.
the source is a query.

when call the function Me.RecordSource, i get the queryname.
is there a possibility to get the text of this query ??
And how ??


thx a lot
Martin

 

[Rick Brandt]

Hi,

ich have a Report with a recordsource.
the source is a query.

when call the function Me.RecordSource, i get the queryname.
is there a possibility to get the text of this query ??
And how ??


thx a lot
Martin

CurrentDB.QueryDefs("QueryName").sql

 

[Pat Hartman \(MVP\)]

This might be a little more generic. I didn't test it though:

CurrentDB.QueryDefs(Me.RecordSource).sql