Getting SQL of RowSource

[Shep]

Is there a way to get the SQL of the RowSource of a ListBox when the RowSource = "(saved query name)", without enumerating the QueryDefs Collection to get the saved query's SQL?

 

[SforSoftware]

Why enumerating the querydefs-collection?
You surely needs the querydef, but I think this will work:
Querydefs(MyListBox.Rowsource).SQL
(not yet tested, sorry )

 

[Shep]

Not to worry...that's what I'm here for!

Result: "Sub or Function not defined" (QueryDefs)

Perhaps I should mention I'm using Access 97...

 

[Shep]

eh....got it

dbs.QueryDefs...etc..

Many thanks, works like a charm

Shep