I'm currently trying to populate a list box with the results of a
query string. Everytime i've used open record set, a simple string name would suffice.

Now i'm using access 2000 and when i complie, the complier barks at me because i have 2 few paramters. I read the parameter list, and some of the parameters i dont understand, could anyone clarify it for me?

db.openrecordset([name as string],[type],[options],[lockedit])

do i need to import a libary to get the right parameter list or something?

thanks

Make certain that you specify that the recordset is of type DAO.recordset. Access 2000 defaults to type ADODB.Recordset recordsets unless you specify DAO.

Usually the problem manifests itself as a library reference, but it could also show up as an invalid or missing parameter.

Rand

You also have to ref. the DAO 3.6 dll

in the VBA-IDE Tools/references