Lookup continuous subform

[naungsai]

Dear Friends

I have built my form with 4 layer of subforms with my MS Access 2010.

Say I have a field, called "text2", in 2nd Subform "subFrm2".

In 3rd subform "SubFrm3", I have an field, called "text3" which is also a combo box.

My question:::
I want to make the drop down of "text3" filtered by "text2".

Both Subfrm2 and SuvFrm3 are continuous forms.

Thanks in advance.

 

[John Big Booty]

You might have trouble with this, unless you are using a query to populate your second Sub form. As derived fields on a continuous form will in all instances reflect the results based on the record that currently hold focus.

 

[naungsai]

Dear John

thanks for you quick response.
Do you have or can you refer me an example file/ article about it??
Thanks again in advance.