Access.Application.CurrentDb is Nothing?
- by Allain Lalonde
I'm at a loss to explain this one:
I'm getting an error "91" (Object or With block not set) on the second line below:
Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("SELECT * FROM employees")
The following also causes it:
Set rs = CurrentDb.OpenRecordset("employees")
Executing ?CurrentDb.Name alone in the immediate window causes the error as well.
Now, clearly the database is open since I'm editing the form within it, so what can cause this error here?
