Dependant Combo Boxes

[BaroldGene]

Alright, so I know this is a common topic, but I can't seem to find anything that I haven't already tried.

I have a form with two combo boxes. THey are interdependant. Basically, one is a general category that contains several subcategories and the other is the subcategories.

I am able to get it set up in such a way that if you pick a general category, only the subcategories related to that category show up. The problem I am having is making the values show up when the form is loaded for records already in the DB.

Since the records involved are only linked to a sub-category, I can't get the general category to update when I change records. Part of this may be due to the delayed load time of the fields that I'm trying to base the general category off of. Either way, the general categories are attached to the records involved, but this is done through two tables. Product Table -> specific category table -> general category table.

Any help on this?

 

[BaroldGene]

After giving this some more thought, basically what I need is to base the starting value of a field off of a value that a record has via relation. The general category is attached to the record via a chain and I need to set a combo box to have this as a default value. The default value field doesn't work because it isn't updated when you change records. I can't set a control source because the record itself doesn't have this information in it, the information is connected via a chain of table relationships, all of them one-to-many.

Any of you access wizards out there have any suggestions?