Error 2950

I have a form that on open runs a query. On close it runs a second query.
Both are dealing with a file that is keeping track of how much time I spend
on the form. But, when the form is open, you cannot run the query to look at
the time. I get a 2950 error telling me that the query is too complex. If I
close the form, then the query can run. I tried to close the table after the
first query runs, but that did not seem to help. Any ideas?