access 2000/97 VBA objects

[grnfvr]

I have a new job and am now using office 2000. They changed up the Access object library. specifically im having trouble seting the recordsource of a query. I have found the new allqueries collection. I have also found the accessobject object. how do i get to the query's recordsource property? Any help would be appreciated.

 

[Mossoft]

Set a reference to DAO 3.6 object library then use something like:

Dim qry as DAO.QueryDef

Set qry = Currentdb.QueryDefs(&quot;<query name>&quot
With qry
.SQL = &quot;SELECT blah blah&quot;
<set other properties of query here>
End With

M.