Dlookup Question/Problem

[Guest]

Hi,
Can anyone please see a fault with this line..
stCriteria = "ProductCode=" & Me!ProductCode
Me!QualityCode = DLookup(QualityCode, [dbo_DProduct], stCriteria)

The error im getting is "cannot find the "|" Field Reffered to in the
expression.

Thanks

 

[Guest]

Hi Craig,

Try this instead:

Me!QualityCode = DLookup("QualityCode", "[dbo_DProduct]", stCriteria)

You might also want to use the Nz function, in case the DLookup fails to
find a result. Something like this:

Me!QualityCode = Nz(DLookup("QualityCode", "[dbo_DProduct]", stCriteria), 0)


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[John Vinson]

Hi,
Can anyone please see a fault with this line..
stCriteria = "ProductCode=" & Me!ProductCode
Me!QualityCode = DLookup(QualityCode, [dbo_DProduct], stCriteria)

The error im getting is "cannot find the "|" Field Reffered to in the
expression.

Thanks

Just in addition to Tom's suggestions - if ProductCode is a Text type
field than the stCriteria must include the syntactically required
quotemark delimiters:

stCriteria = "ProductCode = '" & Me.ProductCode & "'"

Also, the first and second arguments to DLookUp must be text strings
containing the name of a field and a table/query - you're not passing
text strings, you're passing the actual value of the field! Try

DLookUp("QualityCode", "dbo_DProduct", stCriteria)

John W. Vinson[MVP]

 

[Guest]

Hi,
Thanks for the replys,
Using the code you have suggested stops the previous error but its throwing
a new one out, Data Mistmatch in Expression, im pretty sure this is due to a
field having different data type but they are all set as text...


Thanks

Hi,
Can anyone please see a fault with this line..
stCriteria = "ProductCode=" & Me!ProductCode
Me!QualityCode = DLookup(QualityCode, [dbo_DProduct], stCriteria)

The error im getting is "cannot find the "|" Field Reffered to in the
expression.

Thanks

Just in addition to Tom's suggestions - if ProductCode is a Text type
field than the stCriteria must include the syntactically required
quotemark delimiters:

stCriteria = "ProductCode = '" & Me.ProductCode & "'"

Also, the first and second arguments to DLookUp must be text strings
containing the name of a field and a table/query - you're not passing
text strings, you're passing the actual value of the field! Try

DLookUp("QualityCode", "dbo_DProduct", stCriteria)

John W. Vinson[MVP]