Microsoft Access 2013 Inside Out

Controlling record navigation with macros

A common use for macros within bound Blank views is to control record navigation. Blank views do not contain a List Control element, which means you cannot navigate to different records. To navigate to different records within Blank views, you must attach embedded macro logic to control events. For example, you could use different command buttons and attach macro logic to their On Click events to navigate between records. You could also use the On Click event of label controls, text boxes, and even image controls.

Let’s create custom Action Bar buttons for record navigation. Click the Invoices table name caption in the Table Selector, click the Invoice Blank view caption in the View Selector, and then click ...