Hi

I would like to add a text box to a report, which just shows the entire query used in the report. I would have thought I could work it out but ...
I saw someone say that a text box with the code =[RecordSource] woudl do it but I have not bee successful.

If I put this in the textbox's Control Source, I get the name of the query used. What I really want, is the entire underlying query that the query used. This is because the query has a short name e.g. exceptions, but there are loads of tables it references.

Any ideas?

in my books not smart to display the query but if you want to you could go through the querydef object to find the details of the query and display them as required

Hey thanks for that. why is that not smart in your view?

To use the querydef object, woudl that need to be VB Code?

why is it not smart?
becuase its exposing your table design to potentially malicious influences. if the system is only going to be used / viewed by the designer then its less likely going to be an issue.

in my books it serves no purpose, no benefit there for no worth. after all the details to query will at worst be documented in the reports design, at best will be documented in the system docs.

to expose the members of the querydef object, yes that will involve dabbling in VBA

OK - appreciate the help.

Thanks