I'm converting an app from DAO to ADO. A form has a data control that is set to a recordset, as...This always worked fine in DAO. Now with ADO, I've changed the code to...Code:Set rsLevelTbl = PROJ_DB.OpenRecordset("SELECT AcctL1 AS ID FROM tblLevel;")
Set Data1.Recordset = rsLevelTbl
Now, I get a "Type Mismatch" error. What gives? Thanks.Code:rsLevelTbl.Open sSQL,PROJ_DB, adOpenKeyset, adLockPessimistic
Set Data1.Recordset = rsLevelTbl
