my code is trying to lookup a record where -
the property id is a text field ;and
the financial year a number field.
initialmedian = DLookup("[prev jun median]", "FY Median", "[Property id]='" & pid & "' And [Financial Year] = FY ")
I get the error the expression you entered as a parameter produced this error: 'FY'
Appreciate any help