Types don't match -OpenRecordset

[Gina]

Hi .

I get an error that Types wouldn't match:

Set DB = CurrentDb()
SQL = "SELECT Kunden.Nachname FROM Kunden"
--> Set rs = DB.OpenRecordset(SQL)

any ideas ??

Thanks Gina

 

[Brendan Reynolds]

Try specifying the DAO object library when declaring the recordset ...
Dim rst AS DAO.Recordset

See the following URL for an explanation ...
http://www.mvps.org/access/bugs/bugs0031.htm