Deleting a report's recordsource

H

Heapy

I have a report that dynamically creates a tabledef which contains the data
it needs to run. I'd like to also be able to delete the tabledef when the
report is closed by the user, however as far as I can tell, when the Close
event triggers, the recordsource has not yet been released. Due to access
control restrictions on the report, I need to hardcode the table name in the
report's control source, so deleting the recordsource programatically during
the close event is also not an option. Is there any way anyone can think of
that would allow me to accomplish this? Is there any way a report can
delete the source of its data?

Thx
HWH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top