Editing a report in code

[biot023]

Does anyone know if & how you could go about setting a report to a temporary QueryDef?
I presently make and afterwards delete a TableDef, but if this could be done more elegantly I'd very much appreciate knowing how.

Cheers,
Douglas JL If it don't make you laugh, it ain't true.

 

[MichaelRed]

Hmmmmmmm,

One approach I use is to modify the RecordSource query in code before opening the report. This is quite straight forward. A minor variation on this is to use a parameter query as the RecordSource.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over