Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DLookUP Error

Status
Not open for further replies.
rwn

rwn

Technical User
Joined
Dec 14, 2002
Messages
420
Location
US
I had a DLookup in Access 2003 and it worked fine as below.
=DLookUp("QTYPER_02","qry_ProductStructure","txtPRTNUM_01=PARPRT_02")

but in Access 2007 is shows ERROR in the field.

Any help is appreciattted. Thank you!
 
Sort by date Sort by votes
This post is in the wrong forum. Please post to Microsoft Office forum.

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

clara1
  • Locked
  • Question Question
unable to add formula field as it displays error
Replies
3
Views
408
kray4660
kray4660
trwebster
  • Locked
  • Question Question
Summary on non-recurring field error
Replies
1
Views
299
kray4660
kray4660
tsh1586
  • Locked
  • Question Question
receiving error message on split formula
Replies
14
Views
824
tsh1586
tsh1586
ggies07
  • Locked
  • Question Question
Formula Errors when adding new Excel file
Replies
2
Views
358
ggies07
ggies07
dikidushi
  • Locked
  • Question Question
Formula error
Replies
2
Views
285
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top