I saw in one of your videos where your student asked about setting up combo box for zones.  Your example showed states that were marked with a zone and then the zone could be automatically assigned by the state on the customer form.  In the extended cut, you showed how to set up an input box to update the zone table from the customer form, however I can't remember what video that was in.  I seem to remember that you wrote vba that would add the state and the zone you entered into the input box into the table automatically. I want to set up vba for my combo boxes that will automatically update the record source when a not in list event occurs and instead of the access automatic response of asking you if you want to add it to the list and then opening the form, it will ask if you want to add it to the list and when you click yes it will just add it without opening the form.  Can someone please tell me which video that was so that I can watch it again?