lookup problem

[mbaddar]

Hi,

This thing is driving me crazy. I have a lookup that's supposed to be checking if a reference number exists for a particular part. The CatalogPage criteria in my lookup does not work. I'm not getting any error messages on this criteria but the lookup is getting data from CatalogPage fields other than the one I specify in my lookup.
Can anyone see anything wrong with this code?

Dim RefCheck As Variant

RefCheck = DLookup("[ReferenceLine]", "BillofMaterials", "[Catalog] = " & """" & Catalog & """" & " AND [CatalogPage] = " & CatalogPage & " AND [ReferenceLine] = " & ReferenceLine)
Thanks a ton for any help,
mbaddar

 

[jurgen]

Why don't you use a sql select statement ?

JJ

 

[TTThio]

Try this...

Dim RefCheck As Variant

RefCheck = DLookup("[ReferenceLine]", "BillofMaterials", "[Catalog] = '" & """" & Catalog & """" & "' AND [CatalogPage] = '" & CatalogPage & "' AND [ReferenceLine] = '" & ReferenceLine&"'&quot

 

[mbaddar]

Hi TTTHio,

I'll try that out and let you know how it works.

Thanks,
mbaddar