Hi Linq,
The field is text, and I tried changing it to include the extra " ' "s that
you instructed and someone else instructed but I'm still not getting it to
work. With that, the code doesn't give an error but it literally returns
blank. Note though that my original code works perfectly IF there's a value
entered. I'm only having this problem if the field is null. Any additional
help would be really great!

"Linq Adams via AccessMonster.com" wrote:

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

.