Report efficiency

[mister]

I am very often creating new reports from different queries – I need to format the reports the same way each time. Is there a short-cut/efficient way to do this so that I am not constantly formatting reports? Is this where I would change the RecordSource in the Properties/Data? If so, is there a way to save the report each time as a new report (to reflect the query from which it was created)? I am new to Access so appreciate any help!

 

[statsman]

Make a copy of the report giving it a new name.

In the report properties, change the control source to the desired query, assuming the query is compatable with the report.

 

[mister]

Thanks. And to find the Control Source, do I go to Property Sheet > Data?
For some reason I am having a difficult time having that option become available.

 

[gemma-the-husky]

is the layout is EXACTLY the same, and you just want a different query, then you can just change the reports recordsource

offhand without checking its either

me.recordsource = "my query name"
or me. sourceobject = "my query name"

these arent alternatives - im just not sure which is correct/available without checking