Create a hyperlink from one data access page to another in the current database

Create a hyperlink from one data access page to another in the current database

  1. Open a data access page in Design view.

  2. On the Insert menu, click Hyperlink.

  3. In the Insert Hyperlink dialog box, click Page in this database under Link to.

  4. 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, then Microsoft Access will use the hyperlink address as the display text.

  5. Click ScreenTip and type the text you want to appear when the mouse pointer hovers over the hyperlink. If you leave the ScreenTip text box blank, Microsoft Access will display the hyperlink address as the ScreenTip.

  6. From the list, select the data access page you want to link to.

  7. To create a filter for the data access page, type an expression in the form of a WHERE clause in the Filter criteria for the data access page box. For example, if you have a data access page that displays order information, including the ID of the salesperson, and you want to link to a second data access page with the employee record about that salesperson, type EmployeeID=[EmployeeID].

  8. Click OK.

    Microsoft Access adds the hyperlink to the data access page. To test the link, switch to Page view and click the hyperlink. Microsoft Access opens the target page in your Web browser.