Cascading Case!

[cap.zadi]

Hello Every One:



A help required.

A have form named "ItemDetails" and there are two fields on it filled up by Como boxes from other tables:

TblCategory
CatID -PK
CatName

TblSubCategory
SCatID - PK
CatID - FK
SCatName


Requirements:

If We, select any value from combo box "CboCategory" fed by TblCategory then only related sub categories should be shown in "CboScategory" fed by TblSCategory.

Regards

[isladogs]

You need to use cascading combo boxes.
Many examples online. For example http://www.fmsinc.com/MicrosoftAcces...cascading.html

[cap.zadi]

Hi

Thanks for efforts.