Linking one report to another

B

BEJ

Currently I have two reports in my DB one list all vendors within a date
range and a second pulls details on a single vendor. Currently if a user is
viewing the first report with multiple vendors and wants the detailed report
they have to open the second report and enter the vendor name in the prompt.
Is there any way I can insert a hyperlink or something else so the user only
has to click on the vendor name and the detail report comes up for that
vendor? I have inserted a hyperlink that pulls the detail report but it still
comes up with the prompt asking for the vendor name. Please let me know if I
need to provide any more information

Thanks for the help
 
G

Golfinray

If possible, it would be much easier to make a form and subform. The main
form would be vendors and the subform would be vendor details. Link the form
to the subform (the wizard should do that for you) or go to the forms and
click properties, data, link master child fields. You could then use a combo
on the main report to select vendor and the vendor details would come up the
the subform. You could use a command button then to print each form or
convert it to a report for printing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top