Hi.
I'm trying to generate a report dynamically based on the selected fields to display. I'm using this as my aid.
http://www.rogersaccesslibrary.com/download3.asp?SampleName=ChooseReportFields.mdb
This stuff is great. And it works!!!!
But what i'm trying to do is:
I have a form with all the possible fields that i want to search the database. In the form searching works perfect! But now I want to create a report which shows fields which are specified by the user by selecting from a list. I can do this if I know that user will be taking the info say only from 2 tables. But i have about 8 tables which are all related through one of them. So how can i anticipate what the user will select??
Is this possible to do???? without creating all the possible cases of what the user can select??? I've been stuck on it for past 2 days. And i'm clueless.
Please... if you guys have any ideas or good info, please share with me.
Is what I'm trying to do even possible???????????
Thank you in advance!
I'm trying to generate a report dynamically based on the selected fields to display. I'm using this as my aid.
http://www.rogersaccesslibrary.com/download3.asp?SampleName=ChooseReportFields.mdb
This stuff is great. And it works!!!!
But what i'm trying to do is:
I have a form with all the possible fields that i want to search the database. In the form searching works perfect! But now I want to create a report which shows fields which are specified by the user by selecting from a list. I can do this if I know that user will be taking the info say only from 2 tables. But i have about 8 tables which are all related through one of them. So how can i anticipate what the user will select??

Please... if you guys have any ideas or good info, please share with me.
Is what I'm trying to do even possible???????????
Thank you in advance!
Last edited: