View SQL or VBA for Report?

[Kimbertha]

Hello Everyone:



Is there a way to view the SQL or VBA for a report similar to the way we can view the SQL for a query?

It seems to me it exists somewhere, but it's been awhile since I've had to work with that and I can't remember how to find it.

Kim

[pbaldy]

In the properties of the report, the record source would be the SQL/query/table the report is based on, and any report level event code could be accessed from the events tab. You could see all code for that report by going into the VBA editor and selecting that report.

[NTC]

PB's advice is always correct. It is the question in this case that is a bit different. A report really can't be reduced to a line of code like a query can with SQL view....unless one is getting into an xml type file..... Otherwise one looks at any of the vba of events (if there are any events...)

[Kimbertha]

Darn. As you all surmised, I was hoping for an SQL-like cheat sheet of all the report's objects and their contents, formulas, properties, placement, etc. But it makes sense that such a thing does not exist

I guess I remembered editing the VBA for an event in the past. This report has no events so there wouldn't be any code there.

Thanks anyway.

Regards,

Kim