dlookup

[themase]

hello all

any ideas why this dlookup is not working

DLookup("[price]", "[qrynewprice]", "[shareid] = " &
Forms![frmshares]![shareid]) all the fields seem to be ok!

 

[Daniel Pineault]

what filed type is [shareid]?

you might want to try

DLookup("[price]", "[qrynewprice]", "[shareid] = '" &
Forms![frmshares]![shareid] & "'")

and see if that doesn't do the trick.

If the above does not work, when you run the Dlookup as it was written
originally, does it return an error? What value does it return?
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.