Switchboard & Reports

  • Thread starter Thread starter Jeri Lynn
  • Start date Start date
J

Jeri Lynn

I have created numerous reports that have a dialog box box
for report selection. I would like to open the report in
print preview, maximize it, then re-open the report
selection dialog box when the report is closed.

I have a macro attached to each reports to maximize the
window "on open" and a macro to "openform" (the report
selection dialog box) in the "deactivate" properties of
the report form. I've tried to attach a "openform" macro
to the "on close" properties of the report but keep
getting an error.

The "deactivate" macro is working in the report but only
on the first selection. For some reason the next attempt
to select a different report, upon close, takes it back to
a blank screen.

How can I get this report selection dialog box to open
after each report without having to exit the database
after each selection once a report is opened and previewed?

Any help is appreciated: This is the last step on my
database before I share it with other staff.

Jeri Lynn
 
I think you are making it too complicated.

You have a form (set to dialog) to select a report, right? There's no need
to close it when you open a report. In each reports' open event you can use
docmd.maximize. When the report is closed, the form will still be there.
 
Yes, I may be complicating the matter. But I have a main
switchboard and another dialog box for data entry that
offers selections. I want them to close and re-open as
well.

On the data entry form I was able to add a command button
to "closeform" and re-open the data entry dialog box.

However, I was unable to insert a command button on the
reports to "closeform" and re-open the print selection
dialog box.

I don't want to leave the reports selection dialog box
open when the data entry or switchboard are open.

I have the report open event set to maximize. Does
docmd.maximize do something different?

Thanks!
 
Can't you just let user's open and close the forms?

You should be able to use DoCmd.Open "formname" in the close event of the
report.
 
I want users to be navigated at the end of either a report
or data entry back to the dialog box the selection
originated from when a selection is completed.

How can I get the report to close then re-open the dialog
box?
 
Back
Top