Adding report to a menu (.adp)

[Laurie Meacham]

I have created a report based on a view and the form needed to select which
record to view and print.

How do I add this report to the menu, so a user can go to the menu, select
the report and enter criteria of which records to select.

I am modifying an exsisting .ADP using enterprise manager SQL. I am able to
create reports, queries and forms, but am at a loss as to how to get them in
the menu.

Please help. Thanks

 

[Sylvain Lafontaine]

Difficult because the report must read these parameters from somewhere and
the easiest way to read them is from an opened form. Instead of opening a
report from the menu, you should open a form where the user can fill the
various parameters. Later, the form can open the report and transmit it the
necessary values.

For examples on how to use a form to open a report, see the thread « Input
Parameters - multiple invoking forms » on 2007-12-04 of this newsgroup as
well as many post in the newsgroup m.p.access.adp.sqlserver; which is the
official newsgroup for ADP.