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.

Chris,

If you use the Wizard to create the combo box the first choice you
make is where this will help. One of the choices you can select is
"Find a record on my form based on value in combo box". If you select
that, your form should display the proper info. (Assuming your
relationships are right)

Russ

On Fri, 4 Jun 2004 10:55:23 -0700, "Chris"
<(E-Mail Removed)> wrote:

>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.