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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to always get the top level form reference, when calling from any subform/subform... 0
Unremovable horizontal scroll bar on subform 1
Update (refresh) Subform#1 when a check box is selected on Subform 8
Pause Subform 1
Subform within Subform Relationship is Indeterminate 4
First Subform record gets modified when closing form 3
Using an append query in a subform 1
Highlight rows in a subform datasheet view 0

Back
Top