Dlookup

[Tom]

HI there

I am using the dlook up function, and its working fine
till i dont use the criteria, once i put in the criteria
it dosent work.
Following is the code which is not working

Dim varX As Variant
varX = DLookup("[F_Flag]", "Flag Support", "[P_Name]=" &
Forms![output calculation]!P_Name)

If i remove the criteria itw working fine.

I would appreciate if someone would help me on this.

Thank you.

 

[Douglas J. Steele]

What is P_Name: a text field? If so, you need to enclose the value you're
passing in quotes:

Dim varX As Variant
varX = DLookup("[F_Flag]", "Flag Support", "[P_Name]=" & Chr$(34) &
Forms![output calculation]!P_Name & Chr$(34))

Chr$(34) returns ", in case you were wondering.