Getting a value in a sub form and pass it to another subform

NaviDev

Hello,

I having difficulty on on how to this scenario.

I have :
- Main Form which contains source table as "Division".
- In the Main there are 2 subforms.
1. Department Subform
2. Item Subform.

What I want is :
1. When I select in the main form a Division record the Department subform will only show the departments under that division. (I Already did this, and its working fine).
2. When I browse in the second subform(departments), the third subform should only show the items under that Division and Department.

How can I achieve the second requirement? Please suggest me. Thanks.

NaviDev

I think already got the solution here viewtopic.php?f=23&t=30045&hilit=subforms+in+a+form.

Thanks anyways.