Hello,
I am working with Access 2003 and I have a table that has a subdatasheet
with more information from another table. The way that it is displayed in
Datasheet view with the subdatasheets visible perfect for what I am doing. I
would like to be able to print that out showing all records and subdata
records. I have tried everything I can think of to make this happen and
cannot figure it out. Additionally I would be able to have that print using
button on a form containing the information, but the most important thing is
being able to print it period. If anyone has any suggestions that would be
great.
Thanks in advance

Create a report based on the main referenced table and another based on the
referencing table (the report wizard will do most of the work for you). Then
embed the second report in the detailed section of the first report, linking
them on the relevant keys. You can then print the report. A report also
gives you much greater control over formatting and layout.

Printing from a button on a form is simply a case of opening the report with
the button. Again the button wizard will create the code for you. You can
also build in the option to filter the report if necessary, e.g. to the
current record or to a subset of records identified by a criterion or
selected in a multi-select list box. Post back if you need guidance on how
to do that.

Ken Sheridan
Stafford, England

"cmoody11" wrote:

> Hello,
> I am working with Access 2003 and I have a table that has a subdatasheet
> with more information from another table. The way that it is displayed in
> Datasheet view with the subdatasheets visible perfect for what I am doing. I
> would like to be able to print that out showing all records and subdata
> records. I have tried everything I can think of to make this happen and
> cannot figure it out. Additionally I would be able to have that print using
> button on a form containing the information, but the most important thing is
> being able to print it period. If anyone has any suggestions that would be
> great.
> Thanks in advance

Thank you very much. I dont know why I did not think about trying with a
report. It worked perfectly and now I can print and change the format!

"Ken Sheridan" wrote:

> Create a report based on the main referenced table and another based on the
> referencing table (the report wizard will do most of the work for you). Then
> embed the second report in the detailed section of the first report, linking
> them on the relevant keys. You can then print the report. A report also
> gives you much greater control over formatting and layout.
>
> Printing from a button on a form is simply a case of opening the report with
> the button. Again the button wizard will create the code for you. You can
> also build in the option to filter the report if necessary, e.g. to the
> current record or to a subset of records identified by a criterion or
> selected in a multi-select list box. Post back if you need guidance on how
> to do that.
>
> Ken Sheridan
> Stafford, England