Let's shift gears a bit and take a look at macros.

A macro is an object that automates tasks. It is a set of one or more actions that perform specific operations. That definition, plagiarized from Access Help, gives you little idea of what macros are or how you can use them. Let's create a macro to get a better feel:

If the frmOrders form is still open, close it and save your changes.
In the Database window, click the Macros button and choose New. Unlike other Access objects, there is only this one view for a macro.
Press F11 to switch to the Database window. Click the Forms tab.
Choose Window, Tile Vertically.
Select frmCustomers. Drag and drop its icon to the first row of the Action column, which now reads OpenForm. You have ...

Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.