Does your query have a start time and end time.
If so, you can't run the query to see your time on Paper with Paper still
open as you will not have an end time and the query will (when you try and
open it) try a half calculation (that like say 1 + = intead of 1 + 1 =).

Maybe I am not understanding.

Can you post the sql so we cna see it


--
Wayne
Manchester, England.



"relativehunter" wrote:version

I am having a problem with a form and a query. When I open the form (called
Paper), it runs a query that adds a row to a table called Time. If Paper is
open and I try to run a query to see my total time on the form, I get a 2950
error. If I close the Paper form, then I have no problem calling the total
time query. I tried doing an explicit close of the Time table in the macro
that sends the row to the Time table, but that did not solve the problem. Any
ideas?