From the course: Access: Building a Sales Database

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Creating a macro that opens a form

Creating a macro that opens a form - Microsoft Access Tutorial

From the course: Access: Building a Sales Database

Start my 1-month free trial

Creating a macro that opens a form

“

- [Instructor] It's easy enough to click on a form in the All Access Objects panel, but what if you have lots and lots of objects in that panel, many with similar names? Or what if you want to be able to open a form from within a report or a navigation form? If you want that level of automation, macros are your answer. Macros are made up of actions, tasks and procedures you choose from categorized groups to be performed in an order you specify. So I'm going to go to the Create tab, and then here on the far end I'm gonna click Macro. Notice the Action Catalog on the right. These are all the categories I talked about. And you can click the little triangles to expand and collapse them. They're just groups of actions, and they put them in these folders to help you find them. The same list exists here in this drop list, and it's all those actions, just alphabetized. So once you're familiar with the actions, you can just choose them from this list. Now I wanna create a macro that opens a…

Contents