I have a table setup for zipcode and territory code for our company. I have the zipcode listbox on a main form and need to have the territory code default into a text box on the subform based on which zipcode is selected. Is this possible?