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

  • Thread starter Thread starter ryanr
  • Start date Start date
R

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.
 
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.
Click to expand...
Have you correctly related the two forms using your primary and foreign
keys?

Keith.
www.keithwilby.com
 
The tables which are referenced by the forms and subforms with primary and
foreign keys with 1 to many relationships.
 
ryanr said:
The tables which are referenced by the forms and subforms with primary and
foreign keys with 1 to many relationships.
Click to expand...
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.
 
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
 
ryanr said:
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.
Click to expand...
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.
 
Back
Top