1 Subform record displayed in report
Hi, I have a form (see attached image) that contains several subforms.
I want to create a report that will display the info displayed in the current record.
I can easily create a report to show all the details on the left of the image eg: company name and telephone etc.
The problem arises when I want to display the address information. There can be several address types in this subform including "delivery" and "billing" etc.
When I create the report it lists all the addresses. I only want the user selected address (the one displaying on the form) to show in the report.
I need some filter/query to do this but how do I say "Select the record displayed on the screen" in an expression? does it have anything to do with the "Me" statement? Any pointers/advise welcome. Many thanks.
Hi, I have a form (see attached image) that contains several subforms.
I want to create a report that will display the info displayed in the current record.
I can easily create a report to show all the details on the left of the image eg: company name and telephone etc.
The problem arises when I want to display the address information. There can be several address types in this subform including "delivery" and "billing" etc.
When I create the report it lists all the addresses. I only want the user selected address (the one displaying on the form) to show in the report.
I need some filter/query to do this but how do I say "Select the record displayed on the screen" in an expression? does it have anything to do with the "Me" statement? Any pointers/advise welcome. Many thanks.
Attachments
Last edited: