if you select a customer the second combo generates parts only for that customer, this seems to work okay and saves the data to my table. Move to a new record and select another customer and part, then when you scroll through records the second combo doesn't show previous selections in records. why? I have looked at row source type (set to table/Query) tried setting data entry to yes