Subform in subform

[Guest]

I have built a form, and the form has a subform. The subform also has a
subform (which I will refer to as SubSubForm).
Questions:
1. Is is OK to have subforms of subforms?
2. As you might expect, the form uses a table that is a parent to the table
in the subform. The table in the subform is a parent to the table in the
SubSubForm. When I open the form, I have 3 record selectors, one for each
of the three tables/forms. However, the record selector for the SubSubform
shows the record number for the current record, but never shows the total
numer of records on the right side. (The other 2 selectors do indeed show
the current record and the total number of records to the right. Why is the
total number of records missing?
3. I can use the record selector on the SubSubForm to click through the
records, but the data fields are blank. However, it does go through the
proper number of records. That is the SubSubForm table may have 3 records
for the first parent record and two records for the next parent record, the
clicking the selector will show 3 blank fields (set for continuous forms) for
the first parent and 2 blank fields for the second parent, but the fields are
blank rather than displaying the information that is actually in the field.
I should also say that this does not happen when I first open the form and I
am on the first record of the main form. It only happens when I move to the
next record in the highest level table.

Any thoughts would be appreciated.
Thanks,
David

 

[Ron2006]

Question 1: Yes that is allowed and OK.

Question 2: Unusual. Is the subsubform wide enough? Is there maybe
just not enough space to show it.?

Question 3: Are the fields in the subforms truly bound fields? In the
design view you should see a field name in the field. If they are
unbound it will show "Unbound" as field name and display just like you
are desscribing.

I can't duplicate you findings - which means only that I can't
duplicate your findings relative to the 2 of xxxxx problem.

 

[Guest]

Ron,
Thanks for the reply. I believe I now understand the problem, just not the
resolution. See if this helps.
I will refer to the three parts of the form as (1) form, (2) subform and (3)
subsubform.
The subsubform has a SELECT statement as the row source. The problem is the
select statement gets executed when the whole 3 part form first opens, but
when the record changes at the form level, the select statement at the
subsubform level does not get re-executed. Because of that, the keys in the
records in the subsubform can't be related to the results of the SELECT
statement because the SELECT statement has the result related to the first
record, and was never re-executed when the record changed.
Does that make any sense? I guess the question is, how do I get the SELECT
statement (which is the row source for the subsubform) to run every time the
highest level record changes?

Thanks very much for your help.
David

 

[Ron2006]

On mine they do get refreshed automatically, so let's step back a step.

Do you find a true parent child relationship in the data tab of the
properties for subform?

And also do you find a true parent child relationship in the data tab
of the properties for subsubform.?

Next, If you add a record to the subsubform, and close the main form
and then come back, do you see that record?
If you then go into the table behind subsubform are the records there
WITH the foreign key to the table for the proper record for subform.?

The relationships should be visible in the data tab if you select the
subform itself, when in design view for the main form.