About creating a list box, drop-down list box, or combo box that looks up values
BeforeUpdate Event
Change Event
Create an event procedure
Events and Event Properties Reference
Find out when events occur
LimitToList Property
Order of events for controls on forms
Order of events for forms and subforms
Order of events for records on forms
Run a macro or event procedure for an event on a form, report, or control