subform within subform not visible in form view

[Guest]

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.

Thanks,
Rudy

 

[John Vinson]

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.

An invisible subform usually means that its Recordsource is a query
which is a) empty and b) not updateable. You don't see the existing
records because there are none, and you don't see the blank "new
record" because you can't add new records to a non-updateable query!

What is the Recordsource property of this sub-subform? Please post the
SQL. If you open it in datasheet view do you see data? do you see a
line at the bottom of the datasheet with *> for entering new records?

John W. Vinson[MVP]

 

[Guest]

The Recordsource property -- SELECT tblmajsubsys.ingmajsubsysid,
tblmajsubsys.intmajsysid, tblmajsubsys.strmajsubsys FROM tblmajsubsys;

I do see the line for selecting records and entering new ones, but in form
view i do not see the sub-subform at all. The sub-subform references a table
with 2 records. There are no quiries at all.

Thanks,

Rudy

 

[John Vinson]

The Recordsource property -- SELECT tblmajsubsys.ingmajsubsysid,
tblmajsubsys.intmajsysid, tblmajsubsys.strmajsubsys FROM tblmajsubsys;

I do see the line for selecting records and entering new ones, but in form
view i do not see the sub-subform at all. The sub-subform references a table
with 2 records. There are no quiries at all.

Very odd. So there are two records in tblmajsubsys if you open it in
table datasheet view? What are the Master/Child Link Field values of
the subform?

Your form might be corrupt. If you can't get it working, try deleting
the sub-subform; Compact the database; and recreate the sub-subform.

John W. Vinson[MVP]