open recordset not working like i thought

[rainman89]

[Resolved] open recordset not working like i thought

Hi all,

Does openrecordset only work for queries that are already created? I thought that this would work

Set rs = Db.OpenRecordset("select * from tbl_benchskill where ((studentYearID= Forms!frm_aisreportCard!Text47))", dbOpenDynaset)

but it errors out while

Set rs = Db.OpenRecordset("qry_benchskill", dbOpenDynaset)

doesn't seem to cause any problems.. Any insight?
Thanks

 

[rainman89]

ok i solved my own problem using

sql= "select * from etc....

then rs.openrecordset (sql)

Thanks for looking though