Macros can pull information from other objects to be used in their execution. In this video tutorial, Access database expert Adam Wilbert shows how to name an object on a form and make reference to its value in a macro. To complete the reference, you need to tell Access to go into the forms group, find the form name, and then find the object on that form.
- Macros could pull information from other objects…to be used in their execution.…If I open up the employee directory either…by double-clicking on it here on the navigation pane…or simply pressing this big button here on the Main Menu,…that'll open it up.…And you'll see that it's a long, continuous form…that I can scroll through to see all the different…employees' contact information.…Now it's a little bit cumbersome to scroll…to the correct employee.…So what I want to do is return to the Main Menu,…and I want to put a text box here on the Main Menu form…that I can type in their employee ID number…and then jump right to the contact information…for that specific employee.…
Let's start the process by taking this Main Menu…into design view.…Then I'll grab a text box control.…I'll go ahead and click there on the icon…that has the rectangle with the A and the B.…And I'll come down into my form.…And I'm going to scroll over here to the right a little bit,…and I'll drop one in right about there.…That creates an unbound text box that isn't linked…
- Creating multi-step macros
- Triggering macros
- Running macros at startup
- Adjusting the execution and flow of macros
- Troubleshooting macros