How to change a report to use a different table

  • Thread starter Thread starter Jay Wilson
  • Start date Start date
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
 
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.
 
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.
 
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
 
Back
Top