Filter Subform Combo box based on Mainform Combo box...

[arifmasum]

I am working with case management system. my table structure is like this:
tblCaseBasic
CaseNo - PK
DateFiled
CaseType

tblCaseUpdate
RecordNo - PK
CaseNo
LastDate
NextDate
CaseStage

tblCaseStage
StageID - PK
CaseStage
CaseType

Now my problem is, I want to filter the Combobox field CaseStage according to the combobox field CaseType in main form. Looking for the solution for quite long time. any help will be appriciated. thanks

 

[arifmasum]

thank you so very much for your quick response..