Main form vs Multiple Subforms

[Dedicated]

Main form (Audit Main)
Subform (Employee) child
Subform (Area Audit) child

Problem: In my Table in the Datasheet View - When I clicked on a single record to view the subforms only 1 subform will appear (Employee). I had added the second Subform (Area Audit)this week, so I'm not certain if 2 subforms can be viewed in the Datasheet View or if there are limitations.

Thanks,

 

[dweis]

I don't know of any limitation, however I have a main form with 4 subforms, all in datasheet view. The main form is unbound and has a couple of unbound text boxes. The 1st text box (text1) = the primary key of the 1st subform, say ID number. The other subforms use the master/child link based on their primary key (ID number) = Text1. If you click on the subform's properties and click the ... next to link master or link child, you'll get an error, but you can just type in the values and they will all be linked. Hope this helped.