Help with pulling data into a report from table in a form

aker

New member
Local time
Today, 21:42
Joined
Jan 23, 2013
Messages
3
Hi,
I have a "Meetings" form with records: (date, time, Originator Code etc) with a "Actions" datasheet table at the bottom being a 1:M relationship. One meeting can have many actions.

What I want is a report of this form that has exactly the same data as this form but the datasheet table at the bottom in a more printer friendly view.
I have created a report and have managed to replicate the data by changing the relevant “Control Source” Example: =[Forms]![Meeting]![Originator Code]

However as the form has a table in datasheet view I am not sure how I can add it to the report.

I have attached a word doc with pictures making this a lot more easier to understand.

Thanks.
 

Attachments

How about a Sub-Report with the table from the datasheet as RecordSource and the link them together with "LinkChildFields, LinkMasterFields".
 

Users who are viewing this thread

Back
Top Bottom