85
Hello, I am using Access 2003 to design an inventory database. Please be pacient with this question, I am not sure how exactly to explain what is happening concisely but I will do my best.
I have a form bound to my products table that has two cascading combo boxes, one for category and one for subcategory. When entering a new item these combo boxes cascade correctly and the data is stored in my table. However, when I go back to edit existing records I am encountering an issue. For Example; If I view the records for a specific vendor there are many items, potentially in different categories. As I scroll through the items only one category has visable subcategory information. For Example; All the items with the category Clothing have their subcategory visable but items in category Jewelry have a blank field for the subcategory. If I reselect jewelry from the category combo box of that record the subcategory becomes visable. As I scroll through the records now only those items in category Jewelry show their subcategories. I would like to view the subcategory for every record without having to reselect the category.
My current though is that I need to requery when I view a new record. My issue is that I have no idea which event that would be, and I'm not sure which box (or would it be the form?) that I would have to place the event on.
Any advice or pointers on this would be appreciated. If you need any additional information about the specifics of my set-up just let me know and I can post them. Thanks for all your help!
