I'm converting an app from DAO to ADO. A form has a data control that is set to a recordset, as...
Code:
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...
Code:
rsLevelTbl.Open sSQL,PROJ_DB, adOpenKeyset, adLockPessimistic
Set Data1.Recordset = rsLevelTbl
Now, I get a "Type Mismatch" error. What gives? Thanks.