Access 2007 FAQ
How can I open objects from the Navigation Pane with only a single click?
Right-click the top of the Navigation Pane and then click Navigation Options on the shortcut menu, as shown in the following screenshot.

Next, select the Single-Click option in the bottom right corner of the Navigation Options dialog box, as seen below.
Finally, click OK on the Navigation Options dialog box to save your changes. Your object names in the Navigation Pane now act like hyperlinks - a single-click opens the object in their default view.
See more tips and tricks like this in our book: Microsoft Office Access 2007 Inside Out
Back to FAQ main page