I'm trying to learn how to use the Macros feature in Access 2010. I have no problem writing the code using VBA, but I need to figure out how to do this with the macros instead.
I have a combo box that has three columns. I want to automatically update a field on the form with the value from the last column when the user selects an option from the drop down box.
The combo box is named EventDate and I'd like to update the EventID once a value is selected.
Here is the VBA in case this helps you to understand what I want to do:
on the afterUpdate event of the [EventDate] combo box: [EventID] = [EventDate].Column(2)