mister
05-09-2008, 02:36 AM
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
05-09-2008, 03:50 AM
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
05-09-2008, 04:03 AM
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
05-09-2008, 05:03 AM
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