Open a form on report open..

[Guest]

How do I open a form when a report is run.

BOb

 

[Guest]

You can add code to the On Open event of the report.

You might get a more complete reply if we knew why you wanted to open the
form. I have created 100s of report and never needed to open a form when a
report opens.

 

[Guest]

The report depends on a query and I am inputing critiria from a form into
the query. If I open the form when I open the report then I do not have to
open the form manully or open the report from the form.

Thanks

 

[fredg]

How do I open a form when a report is run.

BOb

Answered elsewhere.
Please do not multi-post. If you feel you must post the same question
to more than one newsgroup (and it's seldom necessary), cross-post by
adding each additional newsgroup in the To Newsgroups: box, separated
by a comma.
This way an answer in one newsgroup will be seen in each of the
others. More readers will see the response and learn, and less time
will be spent on duplicate answers.

See Netiquette at http://www.mvps.org/access

It's a great site to visit anyway.

 

[Larry Linson]

I gather this Report (and Form) will not be part of an application. If they
were, I'd think it simpler to do the traditional thing, which is open a Form
into which the user enters criteria information, and from that Form, open
the Report. And, if you use the Report frequently enough to need or want to
create a Form for entering Criteria, maybe it is suitable for inclusion in
an application.

But, as Duane pointed out, you can modify the RecordSource of the Report in
its Open event. You will need to make your Form Modal, however, or it will
Open but the code and Report will continue to execute without waiting for
the Form to Close.

Larry Linson
Microsoft Access MVP