Change Control Source of Report

[pnpez]

Hello,
I am creating many reports that are essentially the same, with a few tweaks. So is there a way to change the control source in a report, meaning change it from table-x to table-z, but keep the report in tact, because many of the field names are identical?

Thanks

 

[vbaInet]

Yes and no! Yes it can be changed on the fly, no because you won't be able to linked the controls to the appropriate fields with ease.

Can you tell us what the differences are?

 

[pnpez]

I was able to change it thru "record source" in properties when I clicked on the top left of the report. It appears that it is running okay. I only had to make a few changes to the names of the fields. Thanks for your help.
Paul