April 9, 2008

Use hyperlinks to open an Access database object without programming

Date: April 8th, 2008

Author: Mary Ann Richardson

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:

Open a blank form in Design view.
Place a Label control on the form.
Type Click to display the Product Categories List to change the label’s caption, then press Enter.
Right-click Label and select Properties.
Click order online viagra in the Hyperlink SubAddress property in the Label property sheet.
Click the Build button.
Click the Object In This Database button.
Click Tables.
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.