Hyperlink to a report from a record in a table

  • Thread starter Thread starter R. Lee White
  • Start date Start date
R

R. Lee White

Hi- I would like to be able to go to a record in a report from the record in
the table. For example, if we are talking about a specific record, I would
like to jump to that record in report view as oppose to opening the report
and scrolling to the specific record. I am using Access 2007.
 
I copied this from the Acces 2003 Help on Hyperlinks. I hope this helps.


:
Create a link to a table, query, form, report, or data access page

Open a form or a report in Design view.
Click Insert Hyperlink on the toolbar.
In the Insert Hyperlink dialog box, click Object in this database under Link
to.
In the Text to display box, type the text that you want displayed in the
field or text box. If you leave the box blank, Access will use the type of
object and the object name as the display text.
Click ScreenTip, and type the text that you want to appear when the user
rests the pointer on the hyperlink. If you leave the ScreenTip text box
blank, Access will display the type of object and the object name as the
ScreenTip.
From the list, select the database object that you want to link to.
Click OK.
Access adds the hyperlink in a label. To test the link, right-click the
label, point to Hyperlink on the shortcut menu, and then click Open.

Rob M
 
Back
Top