How to Reset a report back to default state before closing report

[sashanktripathi]

Hi,
I have a report which fetches a row from a table during report_load event and populates the relevant labels and sets the subforms recordsource.
I have an exit button and would like to reset the controls and recordsource back to its previous(default) state as it was before report_load.

Why I want to do do this:
When i open a report (from a form button click) for the first time, it invokes the report_load event, but when i return back to main form from the report (through button click) and select another record, the report opens up with the previous record

I have tried the below:
in report exit button click event:
I am unable to unload the report(Unload Me),
Docmd.close is not unloading the report

online solutions i found:
invoke the OnOpen command of report, (please assist)
set recordsource of subform to nothing (not helpful)
Please help...

[zmbd]

+ As for your code, without yours, it's fairly difficult to help you with this particular issue. Please make sure that you select your VBA Script and format it using the [CODE/] tool.

+ Normally, you wouldn't have the report drive things on the form. However, I would look at the on_close event of the report to interact with your form.

+ Normally one would be passing the information to the report from the form when the report is opened not pulling information from the form to the report.

There are various methods normally used to do this; however, AFIK, parameterized queries based on forms tend to be one of the more common methods followed by "Open Augments" and filters.

I do have a database where the report does drive the user interface on initial opening; however, this only because:
1) The underlying report record source is a query based on a form that collects user input. This forces the report loading to halt because the query needs information which results in the form opening (no vba :) )
2) Once the user clicks on [Submit] the form is hidden (and if the report is closed, reopens the report which because the form is already open the query runs and the reports opens); thus, allowing the report to finish loading.
3) The report's on_close event unhides the form for more user interaction if needed.

+ IMHO, your report should not be setting record sources in the calling form - especially subform(s). The subform(s) should normally be handled by the parent form, not a report.

+ One of these threads may provide you with a few ideas on how to approach your report/interaction from a different angle:Search results on Bytes.com Key words: [open report with current record] (read more)

when we have a bit more information about your on_load event code we can go from there if you insist on going this route.