G
Guest
I have Form A which displays ceratin data to the users. From Form A the
users have the option to run various sub reports with user defined parameters
off of the displayed data on the fly. These sub reports procedures run
designated queries and create temp tables as the source for pre designed
reports which display the results. The users also have the option after
viewing these reports to close and return to Form A and run the same sub
reports with a different paremeters in which case the procedures delete the
existing temp tables before the new report is run.
My issue is that when the users view a sub report but fail to close the
object prior to running the same report with different parameters from Form A
the open report keeps the temp table in question locked therefore giving an
error when my procedure attempts to delete the temp table prior to creating
the new ones.
Any suggestions on how to force Reports to close on LostFocus or any other
solution to this issue?
Your assistance will be greatly appreciated...thank you.
A.S.
users have the option to run various sub reports with user defined parameters
off of the displayed data on the fly. These sub reports procedures run
designated queries and create temp tables as the source for pre designed
reports which display the results. The users also have the option after
viewing these reports to close and return to Form A and run the same sub
reports with a different paremeters in which case the procedures delete the
existing temp tables before the new report is run.
My issue is that when the users view a sub report but fail to close the
object prior to running the same report with different parameters from Form A
the open report keeps the temp table in question locked therefore giving an
error when my procedure attempts to delete the temp table prior to creating
the new ones.
Any suggestions on how to force Reports to close on LostFocus or any other
solution to this issue?
Your assistance will be greatly appreciated...thank you.
A.S.