Can someone confirm or deny this for me? I'm working in an MDB file, but am wanting to assign an adodb.recordset to a forms recordset property, and am getting errors trying this. Using a DAO.recordset works fine. I read somewhere that forms in mdb files use DAO, and in ADP files use ADO - So I assume therefore that you cant do what I want, but the help file leaves ample room to assume you can do this - so could someone clear this up for me?
Here's an simplified example of what I want to do - this code would exist in a form:
Public Sub DetermineRecordset()
dim r as new adob.recordset
r.open "SELECT Stuff FROM sometable WHERE igetwhatIwant=true", connection etc etc etc
set me.recordset = r ' << Error occurs here for ado, but not dao Can I persuade this to work?
I know its not many points, but a yes or no is proably all I need - if yes I'll ask the question of how for more points