From the course: Access 2019: Macros
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Pull input variables from forms
- 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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.