You syntax is for DLookUp() is incorrect for either Text or Numeric field.

Assuming that your reference to

Me.Parent!Measurements

is correct, in your original code (I haven't worked with sub/subforms like
this)

If Measurements is Numeric it would be:

DLookup("Expr1", "qryMeasurements", "Measurements = " & Me.Parent!
Measurements)

If Measurements is Text:

DLookup("Expr1", "qryMeasurements", "Measurements ='" & Me.Parent!
Measurements & "'")

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201001/1