CREATING A RECORDSET AND MAKING IT FORM'S RECORDSET

[tzigone]

Hi!
I want to create a table in my vba code. This table does not exist in database, it will only appear in an access form. That is I want this recorset to be the recordset of my form.

dim myrs as new adodb.recordset

myrs.fields.append "score",adinteger
with myrs
.addnew
.fields("score&quot=1
end with

set me.recordset=myrs

This produces run-time error 7965( The object you entered is not valid recordset property".

How can I solve this problem?
Thank you

 

[RoyVidar]

Hi!

Forms recordset (unless you're using adp/sql backend) are DAO, so the recordset needs to be so to.

If not adp, then be sure there's a reference to the dao library, and use dao code.

HTH Roy-Vidar