Subform in a Subform

[Njliven]

I have a Main Form with a subform and that suform has a subform. It is all working in a single form view. I would like both of the subforms to be in datasheet view. Is this possible? It let me change the views to datasheet view, but only the first subform shows up. The other form does not show. Any suggestions would be very helpful. Thanks!

[Bob Fitz]

I have a Main Form with a subform and that suform has a subform. It is all working in a single form view. I would like both of the subforms to be in datasheet view. Is this possible? It let me change the views to datasheet view, but only the first subform shows up. The other form does not show. Any suggestions would be very helpful. Thanks!

I don't think a datasheet form can have a subform. Perhaps your first subform could be shown as a continuous form that looks like a datasheet.

[Missinglinq]

A Datasheet View Form can, in fact, have a Subform, but it appears as a (+) (Plus Sign) on the Parent Form Record. To view the Subform(s) for a given Record you click on the (+). In order for all of the Subforms to be dropped down when your MainForm (Parent Form Record) opens, in, that Parent Form Record use this code

Private Sub Form_Load()
  Me.SubdatasheetExpanded = True
End Sub

As Continuous View Form cannot, natively, contain a Subform. The workaround for having a Subform when the Main Form is in Continuous View requires that you put the Subform either in the Header or the Footer of your Main Form. TO escape the wrath of the Access Gnomes you have to:

• Create your Main Form in Single Form View
• Place the Subform in Header or Footer, whichever you like
• Save the Form
• Now go into Properties and change the Form's Default View to Continuous View Form

Linq ;0)>

[Njliven]

It was working all along, I just could not see that it was working until I put a record in the subform. The the the plus sign showed up and I could add records to the then to that subform. So the second subform actually shows per each record in the 1st subform. Thanks for the help. Hopefully this will help someone else with the same issue.