• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 417
  • Last Modified:

New DLookup syntax issue

What is wrong with:

Me.txtPaintLT = DLookup("[Leadtime]", "tblOutProcessLeadtimes", [Desc] = "Paint")

Am using it in an afterupdate event of a combobox on a form. I get runtime error 2465.
0
SteveL13
Asked:
SteveL13
1 Solution
 
Rey Obrero (Capricorn1)Commented:
Me.txtPaintLT = DLookup("[Leadtime]", "tblOutProcessLeadtimes", "[Desc] = 'Paint'")
0
 
SteveL13Author Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now