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