Deleting a table - timing conflicts

[Armando]

I created a report to display all the tables/fields in a db, and all the
code is in the report's module - for easy one-chunk portability to other
apps. In the OnOpen, I create a temp table, fill it from the tabledefs
collection, then open the report. Works fine. In the OnClose, I want to
delete the table, but the report still has hold of it. I've tried a number
of ways to delay the delete (DoEvents, empty For loop, dummy MsgBox), but no
luck. I don't know what other event to hang this on. I was able to *empty*
the table onClose, but I really like to delete it for a clean exit. Ideas?

Thanks,

Armando

[pietlinden]

Why not cheat and open a hidden form and then close it when the report
closes. Then you can clear the table when the hidden form closes.

[Armando]

I've thought along similar lines, but would really like it all to be in one
piece, just the report I can drop into any app and it's ready to go out of
the box. I forgot to mention I also tried changing the report's record
source to "" before deleting the table, but I'm not allowed to do that after
the report is open. Funny, I used to do that in the past - open a report,
THEN tell it what its record source is (same report reused from several
places) - not sure why I can't do that anymore.

Thanks! Armando

<pi********@hotmail.comwrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...

Why not cheat and open a hidden form and then close it when the report
closes. Then you can clear the table when the hidden form closes.