Sub Form within Sub Form

Pilotwings_64

Registered User.
Local time
Today, 10:00
Joined
Aug 20, 2010
Messages
14
I just started using access last night, and have only used it for about 6 hours since then, so I apologize if this is a question with an easy answer. I have not been able to find the answer online.
In the file I've posted I have a form called, ErrorsF. At the bottom left of the form is a sub form with another sub form within it. In design view they both show up, in either of the other two views only the highest level sub form shows up, but not the sub form within it.

Does anyone know how I can fix this?

Thanks
 

Attachments

Take the form ErrFactVerF out of the footer and place it in the main form.

ErrosF

you will then see the results
 
Thank you for the reply. I put ErrFactVerF in the main body of ErrFactsF, but I still cannot see the info outside of design view.

A user on another forum told me,

"The reason that your subform does not display is that a form in datasheet view can't have a subform."

"I would suggest that rather than a subform, you create a query using ErrFact and ErrVer to use as the recordsource of the ErrorsForm."

Though, I have not yet figured out how to use a query to get the results I was trying to get with the subforms.

Does anyone have any ideas?

Thanks again
 
For what it's worth, I don't care if the ErrFactVerF is a subform within ErrFactsF or ErrorsF. All I care about is that ErrFactVerF displays information linked to the record selected in ErrFactsF.
 
Thank you for the reply. I put ErrFactVerF in the main body of ErrFactsF, but I still cannot see the info outside of design view.

I suggested placing the ErrFactVerF in the main form not the other subform.

You may not need a query in the forms it is about Link Master and Child relationships in the properties which will help display your records/data.
 
Okay, I put it in the main form. I have never dealt with the Master/Child relationship. I assume that I want the FactID field in ErrFactsF to be the Master and the FactID in ErrFactVerF to be the child. I attached a screen shot of what is happening when I try this.

It is only offering me the option of making fields from the main form the master.
 

Attachments

  • Untitled.jpg
    Untitled.jpg
    97.9 KB · Views: 83

Users who are viewing this thread

Back
Top Bottom