Another dynamic report qeustion. HELP

szymek_d

Registered User.
Local time
Today, 07:42
Joined
May 26, 2005
Messages
21
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!
 
Last edited:

Users who are viewing this thread

Back
Top Bottom