Requery of Subforms

[Joe]

I have successfully used various methods of requering subforms in the past.

Now, however, I seem to have a hard time to update subforms based on
changing values in cascading combo boxes.

I previously listed 1 or 2 threads but none of them have solved my problem
(this is not to say the I wasn't given any answers... somehow I believe I
didn't understand the given answer), so I'll try again providing more
generic information.

Instead of listing all the details, I will attempt to explain my scenario
with simple example data.

Table Structure:
- 4 tables that are joined via One-To-Many relationship (all follow the
principle of "GrandFather, Father, GrandChild, GrandGrandChild"
architecture).

Form Structure:
- MainForm "GrandFather" has general information (listed in Single Form)
- SubForm "Father" uses ComboBox1
- SubSubForm "GrandChild" uses ComboBox2
- SubSubSubForm "GrandGrandChild" uses ComboBox3


The information in the 3 combo boxes follow the principle of "State",
"City", "Community". For instance:
- ComboBox1 uses values such as "CA" or "TX"
- ComboBox2 uses values such as "LA", "San Francisco", "Austin", "El Paso"
- ComboBox3 uses values such as "LA North, "LA South, ...."Austin North",
"Austin South"...


Okay, here's what I need to get to work, but just can't seem to figure out:
- If value in ComboBox1 is changed on Subform (Father), then
- update values in ComboBox2 on SubSubForm (GrandChild) + update values in
ComboBox3 on SubSubSubForm "GrandGrandChild"
- Then, if value in ComboBox2 is change on SubSubForm (GrandChild), then
- update values in ComboBox3 on SubSubSubForm (GrandGrandChild).
.... in other words, if I select "TX" (ComboBox1), then I want to see
"Austin" and "El Paso" (ComboBox2). Then, if I select "Austin"
(ComboBox2), then I want to see "Austin North" and "Austin South"
(ComboBox3).


I have received a few replies in earlier threads. Unfortunately, I still
can't figure out how to write the "Requery" statements that have a domino
effect on multiple combo boxes that ALSO resides on multiple layers of forms
and subforms.

I'd truly appreciate if someone could provide me some pointers as to how fix
that. It would be really beneficial if the sample information of a)
Subform, SubSubForm, and SubSubSubForm and b) ComboBox1, ComboBox2,
ComboBox3 would be used in any help that you might be providing to me.


Thousand thanks to anyone who can help me out,
Joe

 

[Andy]

Joe:

This worked for me w/3 Combo boxes:
Q209595 - ACC2000: How to Synchronize Two Combo Boxes on a Form

Go to Miicrosoft.com and search for the above.

You will need to change Your Primary keys in the tables to txt.

Takes a little time but it works.

Andy

 

[Joe]

Andy:

Thanks for the sharing this resources w/ me. I just downloaded the mdb
file and also the info on the 2 combo boxes.

Joe