Data Management

Use hyperlinks to open an Access database object without programming

You can add a control to your Access database without starting from scratch -- or without knowledge of programming. Here's an easy way to use a hyperlink instead of a command button.

Rather than add a command button to your form to open another object in your database, you can use a hyperlink. Using images, labels and command buttons as hyperlinks is an easy way to add a control that allows users to open and display an object without programming.

To create a hyperlink that opens the Product Categories List table from an unbound form in your database, follow these steps:

  1. Open a blank form in Design view.
  2. Place a Label control on the form.
  3. Type Click to display the Product Categories List to change the label's caption, then press Enter.
  4. Right-click Label and select Properties.
  5. Click in the Hyperlink SubAddress property in the Label property sheet.
  6. Click the Build button.
  7. Click the Object In This Database button.
  8. Click Tables.
  9. Click the Products Categories List, then click OK.

Note that instead of a label, you could also use a command button or image; just change its SubAddress property to the object's address.

Unlike command buttons, hyperlinks only allow you to open an object and move to a location within it. Any programming is limited to the control's on-click event.

Miss an Access tip?

Check out the Microsoft Access archive, and catch up on other Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox