forms -- how to get subcategory list to update when category is change 1

[ronrsr]

I am working on a form that has a combo box for category, then another one for subcategory -- it works fine, except that when I change categories, I'd like to have the subcategory list updated -- now, i only get the original subcategory list displayed.

Does anyone know how to update this whenever categories change by going to a new record?

Thanks,

-rsr-

 

[blodder]

You could try using the onChange event of combo1 and inserting:
combo2.requery

 

[ronrsr]

Hey, that worked great -- only one small problem left --

When I change the category, the choices in the pull-down part of the combo box change -- but the current value of the combo box doesn't. for instance:


Category Subcategory Drop Down


Milk Beverage Beverage, Yogurt, Cheese, Milk Alternatives


change to:


Grains Beverage Breads, Muffins, Rice, etc.


I'd like the new subcategory to be Breads, if possible.

bests,

-rsr-



change to: