sorry posted wrongly

T

themase

hello does anyone know why this dlookup doen't work

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

all the fields appear ok
 
T

themase

Thanks alls works great!

thanks for your help!!

Al Campagna said:
themase,
Try...
DLookup("[price]", "[qrynewprice]", "[shareid] =
Forms![frmshares]![shareid]")
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."


themase said:
hello does anyone know why this dlookup doen't work

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

all the fields appear ok
Click to expand...
Click to expand...
 
Top