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 ...