Printing records in a subdatasheet

[Al]

I have a datasheet opened from a query where I have filtered for certain
records. I have a subdatasheet attached to it. In datasheet view I can
expand the subdatasheet to show records on screen but when I try to print
this the program automatically collapses the subdatasheet and only prints the
primary datasheet records.

How can I stop it from automatically collapsing the subdatasheet when I
print it out?

 

[Jacky]

I'm currently facing the same issue. Additional to the picture, at another
com in my workplace, printing of the subdatasheet in general datasheet table
is perfectly as how it displayed in datasheet view. I've checked, the version
is only Access 2000 (from Office 2000 Professional), older version than my
Office 2003 Professional. Was the feature removed during the update of the
version?

 

[GJeffers]

also having this same problem with access 2k3, haven't tried printing on 2k
yet, is there a work around or a fix for this yet?

 

[Bill Mosca, MS Access MVP]

Use a query with the table joined to the child table instead of relying on
those nasty subdatasheets. Include all the fields you want to print.

SELECT Customers.*, Orders.*
FROM Customers INNER JOIN Orders ON
Customers.CustomerID = Orders.CustomerID