how to code depended queries as object's data source? Thanks

[xpengi]

Hi,

if i define some depended(crosstab) queriese in code, "query12, query13", then i want to set the form's record source is query13, how to do that?

i code as, but not work
...
dim defQuery as String
dim query12, query 13 as QueryDef

query12.SQL= "select.....from students...."
query13.SQL= "select.....from query12......"

defQuery = CurrentDb.QueryDefs(query13).SQL

Me.RecordSource = query13

' i pass the defined query to ADO function to query the database, then get recordset object.
Call modADO.ConnectToThisDatabase
Call modADO.Students(modGlobal.curConn, modGlobal.rsRec, modGlobal.defQuery)
....