timer

I have a report that tries to read from a temp table that I create right
before I call the open report command. Problem is - the report generates a
2580 'record source not available' error because I believe that report is
trying to open too fast. The table probably is not built and closed before
the report is trying to open. I can prove this by waiting for a second once
I press the debug key, then pressing F8 or F5 for the program to continue.
Then the report comes up fine. How can I put a pause or timer for a couple
of seconds before I call the openreport command? I do not know how to use a
timer control in access visual basic or if one exists in Access 2003 vba....

Thanks,
Jason

Rather than using the timer event, copy the code at this site and use it to
delay your code for a second or two:

http://www.mvps.org/access/api/api0021.htm
--
Dave Hargis, Microsoft Access MVP


"85ascMcLaren" wrote:

I have a report that tries to read from a temp table that I create right
before I call the open report command. Problem is - the report generates a
2580 'record source not available' error because I believe that report is
trying to open too fast. The table probably is not built and closed before
the report is trying to open. I can prove this by waiting for a second once
I press the debug key, then pressing F8 or F5 for the program to continue.
Then the report comes up fine. How can I put a pause or timer for a couple
of seconds before I call the openreport command? I do not know how to use a
timer control in access visual basic or if one exists in Access 2003 vba....

Thanks,
Jason