I get a #Name? showing up in the field. This si what i tried
=DLookUp("[Item List]![Case Gross Weight (Kg)]","[Item List]","[Item List]![ITEMNO]=" & [me].[ItemNo])
I also tried this first
=DLookUp("[Case Gross Weight (Kg)]","[Item List]","[ITEMNO]=" & [me].[ItemNo])
and get the same...