subform within subform

  • Thread starter Thread starter Chris
  • Start date Start date
C

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