911 help -- subform within subform not visible in form view

[ryanr]

I have a subform within a subform in design view. The subform within
the
subform is not visible in form view. I have 2 records of data in the
tables
which the subforms reference. What can I do to make all my subform
visible
in form view? No code, just design view of Access.

 

[Keith Wilby]

I have a subform within a subform in design view. The subform within
the
subform is not visible in form view. I have 2 records of data in the
tables
which the subforms reference. What can I do to make all my subform
visible
in form view? No code, just design view of Access.

Have you correctly related the two forms using your primary and foreign
keys?

Keith.
www.keithwilby.com

 

[Guest]

The tables which are referenced by the forms and subforms with primary and
foreign keys with 1 to many relationships.

 

[Keith Wilby]

The tables which are referenced by the forms and subforms with primary and
foreign keys with 1 to many relationships.

But you have to make this link on the forms too. Click on the subform on
it's parent form in design view, then go to the data tab of the properties -
you need to fill in "Link Child/Master Fields".

Keith.

 

[Guest]

Thanks for continuing to help. I just checked these fields on the subforms
and they were correct. When I used the subform from the "Tool Box" and
answered the wizard questions I guess this took care of what you asked me to
check. Please offer another suggestion. I need this form for data entry,
but I just don't understand why it won't show up in form view.

Thanks,
Rudy

 

[Keith Wilby]

Thanks for continuing to help. I just checked these fields on the
subforms
and they were correct. When I used the subform from the "Tool Box" and
answered the wizard questions I guess this took care of what you asked me
to
check. Please offer another suggestion. I need this form for data entry,
but I just don't understand why it won't show up in form view.

OK, struggling a bit now - other things to check:

the subform's "data entry" property is set to "no";
the subform's "allow additions" property is set to "yes";
the subform's "allow edits" property is set to "yes".

Has user-level security been tampered with at all?

Keith.