Object variable not set (Error 91)

[ssanfu]

It looks like you might have a scope problem.
You have a few variables declared twice.

Global vairables:
----------------
Dim Avail As Recordset


Dim Assg As Recordset
Dim Idx2 As Integer


and in the private sub you also have local declarations:
------------------------------------
Dim Avail As DAO.Recordset
Dim Assg As DAO.Recordset
Dim Idx2 As Integer


I am kinda curious as to why you have global variables and why you use a function to open a record set.
Seems to me it would be easier to just use the sub.

[shabyr]

Thanks Steve, This is not my db, I inherited it. It was orginally designed in 2000. I am studying VBA and had to figure alot of the problems on my own. I have upgraded a copy the mdb to accdb, and trying to get all the bugs worked out before actually doing it to the live databases. There are 20 of them, (which includes BE and backup databases). I am at the point it might be wise to pay a developer, however I still will be the one maintaining, so I want to get this down.
There are a lot of statements that I don't understand the programmers logic, all I know is that our production team uses them 24/7, and they don't want to go without. I would love to learn how to make is more efficient, and stable.
-Shannon