sorry posted wrongly

  • Thread starter Thread starter themase
  • Start date Start date
T

themase

hello does anyone know why this dlookup doen't work

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

all the fields appear ok
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dlookup 1
Get a number from a table to a form. 0
Form References 2
pop up form to open one record with dlookup 1
Access 2010 Run-time error '3464' PLEASE HELP FAST 5
DLookup Function 2
Referencing Dlookup in subform 1
Dlookup is broken... 1

Back
Top