Dynamic report based on dynamic query

[Rus925]

I'm working with a dynamic query whose SQL script is determined by a VB
script. Now, I'm trying to figure out how to make a report which would
reflect the query, whatever it might be, and automatically show only the
fields that exist. Any ideas? Thanks in advance!

For more info on the query, if you need it:
http://www.microsoft.com/office/com...ries&mid=e3765ccb-116c-4ddf-b70a-6e35b3a3a591

 

[Marshall Barton]

I'm working with a dynamic query whose SQL script is determined by a VB
script. Now, I'm trying to figure out how to make a report which would
reflect the query, whatever it might be, and automatically show only the
fields that exist.

For more info on the query, if you need it:
http://www.microsoft.com/office/com...ries&mid=e3765ccb-116c-4ddf-b70a-6e35b3a3a591

Can't you use the report's open event to get the list of
fields from the form?

 

[Rus925]

Probably...if I knew how to do that. I know how to edit the open event for
the report, but I don't know what commands would get the field names and put
them in the report. How do I do that?

 

[Marshall Barton]

The basic idea would be similar to the way you figured out
which fields to put in the query. Instead of concatenating
the field names into an SQL statement, you would assign them
to the text boxes' ControlSource.