Create a new data access page and a command button that's a hyperlink to that page

Create a new data access page and a command button that's a hyperlink to that page

  1. Open a form in Design view.

  2. If the Control Wizards tool in the toolbox is pressed in, click it to turn off the Control Wizard.

  3. In the toolbox, click the Command Button tool Command Button control.

  4. On the form, click where you want to place the command button.

  5. Make sure the command button is selected, and then click Properties on the toolbar to open the property sheet for the command button.

  6. In the HyperlinkAddress property, click the Build button .

  7. In the Insert Hyperlink dialog box, click Create New Page under Link to.

  8. In the Text to display box, type the display text for the hyperlink. Microsoft Access automatically displays the value of the command button's Caption property in the box.

  9. Click ScreenTip, and type the text you want to appear when the user rests the mouse pointer on the hyperlink. If you leave the ScreenTip text box blank, Access displays the hyperlink address as the ScreenTip.

  10. In the Name of new document box, type a name for the page.

    Tip   You can create a different type of document, for example, a Word file or and Excel spreadsheet, by typing the three-letter file extension for the type of file you want to create. However, you can't create a Microsoft Access database (.mdb) or a Microsoft Access project (.adp).

  11. Microsoft Access creates the new page in the current folder. To specify a different location, click Change.

  12. Click an option under When to edit. You can edit the new page immediately or wait until later.

  13. Click OK.

    To test the link, right-click the command button, point to Hyperlink on the shortcut menu, and then click Open.