SubReport Formula not working in Access 2000

[mgarces]

I need to create a calculation using a field in a subreport with another field in my main report.

The expression I'm using is:

=[Reports]![rptSubreportName]![subreportfieldname]/[Reports]![rptMainReport]![fieldname]

Its accepting the formula, but when I run the report, I get: #Name?

I've checked me field names and they are correct. Please help. Thanks

 

[dhookom]

It would help if we knew if the text box was on the main report or subreport. Also, make sure the name of the control is not also the name of a field.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.