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.
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.