I am working in Access 2010. I am creating a web based database and I have a sub form created to enter orders/services for customers via a subform(datasheet view). I currently can enter the category of the service and tab to select a service description based on my chosen category, then when I tab to enter a 2nd service for the same customer in a new record one line down, I can select a new category but my service description options are the same as the first selected category. For some reason it is not updating to the newly selected category. What did I miss?

Any help with this would be greatly appreciated!