Hyperlink Alternative

Sometimes we use command buttons to open other Access objects, but there's an easier alternative. This  alternative will also open objects faster than VBA code. Instead of inserting a command button and using code to open other objects, try using a hyperlink. With the form in Design View, choose Insert, Hyperlink. In the Insert Hyperlink dialog box, skip the first text box and enter the name of the object you want to open in the Named Location In File (Optional) control. Or click the appropriate shortcut to the left and point to the object or create the object. Then, click OK.   Access will insert a label with a hyperlink into your form. When you want to open the object named in the hyperlink, simply click it. 

Access Index

Main Index