Linking one report to another

  • Thread starter Thread starter BEJ
  • Start date Start date
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
 
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.
 
Back
Top