Combo Box Problems

[tamalou]

I have two tables a main Categories and SubCategoreis. I have the sub categories table set up as follows:

Pricing Admin
1 A
2 B

Etrc
I have a form. Combo box lists values in Main category table . No problem. the Second Combo Box I have is supposed to list only the sub category values for the Main Category item displayed. Not working. i have tried writign code. Settign up an Expression in the AfterUpdate in the first combo box. i think I am goign to lose my mind. Please help.

 

[BoxHead]

Tamalou,

I'm not tracking on your table layout, but you should be able to modify the SubCategory combo box query.

The folllowing assumes your combo box for MainCategories is Combo1 and for SubCategories it is Combo2.

In the Form design view, select Combo2 and in the property pane click on the elipsis at the end of the rowSource line. This will open the QBE view for the SubCategories combo box.

In the criteria line for the MainCategory field, type:

 [Forms]![yourformname]![Combo1]

Close the query and select yes to save the changes.

Back in Form design view, write

Combo2.Requery

as the BeforeUpdate event on Combo1.


HTH

John