How do I Change a dependent in an Access 2003 report?
I want to change the table an access 2003 report depends on with out recreating the report. How would I go about doing this?
Hi, try the following (this works for 2002 I don’t have a copy of 2003 to hand but assuming they’re the same):
1. Open the report in design view.
2. Right click on the grey area (the blank area to the side of where your actual report is) of the report and select properties. OR click on the properties icon in the toolbar.
3. You should get a popup box with some tabs, Format, Data, etc.
4. Click on the Data tab.
5. Select the new Data Source for the report in the top dropdown.
If your new data source fields are named differently to the existing ones you will need to change the control source of the text boxes that display the values.
You can do this by right clicking on any that need changing and selecting properties, on the Data tab you can select the Control Source from a dropdown list (the field that holds the data you want to show).
Hope this helps, Graham
March 9th, 2010 at 7:07 am
Hi, try the following (this works for 2002 I don’t have a copy of 2003 to hand but assuming they’re the same):
1. Open the report in design view.
2. Right click on the grey area (the blank area to the side of where your actual report is) of the report and select properties. OR click on the properties icon in the toolbar.
3. You should get a popup box with some tabs, Format, Data, etc.
4. Click on the Data tab.
5. Select the new Data Source for the report in the top dropdown.
If your new data source fields are named differently to the existing ones you will need to change the control source of the text boxes that display the values.
You can do this by right clicking on any that need changing and selecting properties, on the Data tab you can select the Control Source from a dropdown list (the field that holds the data you want to show).
Hope this helps, Graham
References :