cascading Combo boxes

[Chatholo]

I need to link the combo boxes Category/Activity and then Country/Business. I have been trying for a while and followed all tutorials but there is something that I am missing and I am not sure what.

Can anyone assist me, I have attached a simplified version of my DB.


The form is an entry for my table NPCosts.

Thanks!
C.

[June7]

cboCategory
RowSource: SELECT DISTINCT Category FROM tblActivity ORDER BY Category;
AfterUpdate event: [Event Procedure]
VBA code: Me.cboActivity.Requery

cboActivity
RowSource: SELECT Activity FROM tblActivity WHERE Category = [cboCategory] ORDER BY Activity;

cboCountry
RowSource: SELECT DISTINCT Market FROM tblCountry_Business ORDER BY Market;
AfterUpdate event: [Event Procedure]
VBA code: Me.cboBusiness.Requery

cboBusiness
RowSource: SELECT Business FROM tblCountry_Business WHERE Market = [cboCountry] ORDER BY Business;

[Chatholo]

Once again June7 THANK YOU!! It works perfectly and I now understand how to do it now. yeah!