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

Why is the DLOOKP function not working on the 'Questions" tab?

I am using this dlookup function on all the tabs, on the upper right hand corner to pull the first incident title.
However, on the "Questions" tab is is giving me an error.

Here is the dlookup function I am using:
=DLookUp("[INCIDENT TITLE:]", "1-Incident-tbl", "[ Incident_ID] = 1")

What is going wrong?
RCQ.zip
Error-on-incident-name---9-2-2014.jpg
0
cssc1
Asked:
cssc1
  • 2
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Do you really have a colon in your field name?

"[INCIDENT TITLE:]"

Jim.
0
 
Gustav BrockCIOCommented:
Or a leading space?

[ Incident_ID]

/gustav
0
 
cssc1Author Commented:
I learned after developing the application I should not use colon in field names.

See attached image for better explaination
Name-.jpg
0
 
Gustav BrockCIOCommented:
Thus the leading space is your error.

/gustav
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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