How to change a report to use a different table

J

Jay Wilson

I am using access2000. I have a report I built a year ago that I would
like to reuse on a new table. How do I tell the report to use the new
table?

Thanks
 
M

Marshall Barton

Jay said:
I am using access2000. I have a report I built a year ago that I would
like to reuse on a new table. How do I tell the report to use the new
table?
Click to expand...


Open the report in design view and change its Record Source
property.
 
F

fredg

I am using access2000. I have a report I built a year ago that I would
like to reuse on a new table. How do I tell the report to use the new
table?

Thanks
Click to expand...

Open the report in design view.
Display the report's property sheet.
Click on the Data tab.
The first property is Recordset.
Change the current recordset to the new table.
As long as all the field names are the same, that's all you need do.
 
K

Karen Todd

I think I wasted half a day messing with properties for individual controls trying to accomplish this same thing

Holy Friday before a holiday weekend lack of brain. Thanks to both you guys for your help

-- Karen
 
Top