types do not match

[matrixknow]

If I try to run my code I got the error "types are not matching"

Set rst = CurrentDb.OpenRecordset(strSQL)

Has this to do with the references ? If yes, which one should you select out of the large library. I don't see why access is annoying the user with what should be basic functionalities as asking to generate a recordset.

I use access2000

 

[PHV]

You must declare rst like this:
Dim rst As DAO.Recordset

and add a reference to the Microsoft DAO 3.x Object Library

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[matrixknow]

thanks, I found it also, you are still quicker ..

Dim rst As DAO.Recordset