subform within subform

[Chris]

I have a main form that has a subform and the subform has
a subform. When a value from a combo box on the first
subform is selected, I want the second subform to pull
values based on the first subform's selection. It doesn't
always get the correct values. I got it to work by
refreshing the second subform when it gets focus, but was
wondering if there is a more efficient way?

Thanks.

 

[John Vinson]

I have a main form that has a subform and the subform has
a subform. When a value from a combo box on the first
subform is selected, I want the second subform to pull
values based on the first subform's selection. It doesn't
always get the correct values. I got it to work by
refreshing the second subform when it gets focus, but was
wondering if there is a more efficient way?

Thanks.

What's the Master Link Field of the sub-subform? Try setting it to the
name of the combo box - this option won't be offered by the wizard but
you can type it in, and it should maintain the link.