Error in report pls help

[Guest]

Dear friends,

I receive an error msg "Microsoft Access can't find the field 'unitweight'
referred to in your expression" allthough the field is there and belongs to
the record source.
When I run the sql query which represents the record source I can find all
the records and fields and nothing seems to be wrong?

Inside the report I refer to that field 'unitweight' inside an expression
from the detail 'on print' event.

Can anyone help me pls?

Thanks
Catalin

 

[John Spencer]

If you don't have the field used on the report then Access will not be
aware of the field even if the field is in the report's record source.

Do you use UnitWeight as the source for a control in the report? If
not, you can always add a control with UnitWeight as the control's
source and set the control's visible property to false (no).



'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[Guest]

You are right. I did not have the field used in the report.

Thanks a lot
Catalin