Printing a table

[cajsoft]

Hi,
I have a form with some fields on it.. it's a subform. It has multiple rows. Is there any way I can print the rows as in a report. I Dont know how to pass the subforum values from the form to the printer? I tried the print table macro but it prints the whole table data and not just the data in the subform

anyone offer any help on this?
thanks
Craig.

 

[ansentry]

You have a Main form and a Subform with a 1-many relationship, and you want to print all the details in the subfrom that relate to the current Main form record, correct?

If so post a copy of you db and I will have a look for you.

 

[cajsoft]

You have a Main form and a Subform with a 1-many relationship, and you want to print all the details in the subfrom that relate to the current Main form record, correct?

If so post a copy of you db and I will have a look for you.

Post a copy of my DB?

table1

clientid
clientname

table2

clientid
Placementname
PlacementAddress
PlacementDate


Ok, I want to be able to print all records in table 2 relating to table1.. How can I accomplish this on a form (print button)

Thanks
Craig.

 

[ansentry]

Have a look at the attached sample.

 

[Carl Foster]

Have you tried saving the form as a report, then printing it?

 

[ansentry]

Have you tried saving the form as a report, then printing it?

What is wrong with my sample, it give him the choice of Main and Sub or just Main.

The is no need to save the form as a report, have a look at my sample its not that hard to do.