Changing info source in report labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to change the source of the data in labels in reports? I
went through quite extensive designing of the actual report and would rather
figure this out than have to start all over. As part of one of the tables on
the report, I currently have an ID number. I would like this label to
display the ID Name instead of the number. Both the ID number and name are
stored in the same original table. I tried to change the control source in
the properties window to the new field, but an error came up (alone with a
message box promping me for the ID Name) when I switched from design view.
Any suggestions?
 
aheath15,
There may be several ways to solve this, but the simplest is....

If you've designed a report the way you want it, you could "copy" that report to a
different name. (rptByIDNo copied and saved to rptByIDName)
And then just change that one field accordingly, and call the reports independently.

Both IDName and IDNo must be included in the appropriate report query/table.
 
Back
Top