Does anyone know a way to make a subform display like the subdatasheets do

Subdatasheets list ALL of category1 ALL of Category2 related to category1 etc...

It appears that with subforms, you can only have the most bottom form be a "Continious Form" and every form on a level above this one, must be a single form


From what I see it cant be done, maybe I'm missing something, it seems the only way is to create an intricate SQL query so that the info resides in one form

Thank You

I'm not sure I fully understand what you are looking for, but have you looked at the Default View property on each subform? You can change it to Datasheet.

Basically I want the functionality and display hirechy of datasheets/subdatasheets.

The form needs to be a working document and formatted for an end user that has minimal Access skills. I guess you could say that I need a detail section that has a detail section in the continious form view.

I think i will just have to hard code a querry that will sort the items based on relating them. the only drawback is that i loose visual asthetics because the records are now on the same level

Thanks again