Access Report Error

[sneupane]

I have created an access report using report wizard from a table A and the report is columnar.The report works fine. Now I want to add a text box in the detail section of report and show a field name 'ImagePath' in that text box from a different table B. When I do these steps and run the report it gives me '#error' in the text field. So what could be the best possible way I could solve this error?


SAR

[SoftwareMatters]

What is the error?
Is it because the text field you are trying to add is not part of the reports Record Source?
If so, put the report in design view, select properties and on the Data tab select Record Source. You need to join in the table and add the field you want in to the field list. Then you can use it on the report.