Run time error 91

[nick]

First time I've seen this one. I read the help file on it and I think I have
my bases covered.

Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim qry As String

.....

qry = "SELECT *" & _
" FROM Employees"

Set rst = db.OpenRecordset(qry)


The "Set" statement throws the error. SHould I be doing something else?

 

[Allen Browne]

Did you Set the variable db before using it?