Syntax Error on DLookup
Hi DBguy,
Something I just realized is that I ONLY get this Syntax Error when the
field is skipped which is then Null. I do have an expression set in my query
to give a result for a null value but I think that's what's throwing this
off. Any suggestions for how to handle that??
"theDBguy" wrote:
Hi Pamela,
Not sure if this will work but try this syntax:
Me.Parent.Form!Measurements
Hope that helps...
"Pamela" wrote:
I have a code that I've copied and used several times but it isn't working in
this one instance. The control to which this is attached is on a subform
nested 4 deep. The control to which it is referring "Measurements" is on
Subform3 (the parent of subform4). Here's my code:
DLookup("Expr1", "qryMeasurements", "Measurements = " &
Me.Parent!Measurements) & " "
Please let me know what I may be missing. Thanks so much!
Pamela
|