Creating a user interface macro

The User Interface Macro is one that gets triggered when you click somewhere on a form.…In the Access 2010 Essential Training course, you learned how to attach a macro to a button.…In this lesson, you will see how to trigger a macro just by clicking in a Form field.…Open up your Customers Order Form, and let's say you are looking at the form,…and it would be handy to have quick access to the SalesReps contact information…just by clicking in the SalesRep field.…There are a few steps to this process.…First, I have to create the little pop- up form, then I have to attach it to the…SalesRep field using an Event macro.…

So click on the SalesReps table, go to the Create tab and choose Form Design.…Click on Add Existing Fields.…We're going to add-in from the SalesReps table EmpID, LastName, FirstName,…CellPhone and Email address.…Now, I have to do a few things here to transform it into a small pop-up.…I will highlight all of the controls, go up to the Format ribbon, and…change these to size 9.…I will also move them up to the top of the form.…