cssc1
asked on
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
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
Or a leading space?
[ Incident_ID]
/gustav
[ Incident_ID]
/gustav
ASKER
I learned after developing the application I should not use colon in field names.
See attached image for better explaination
Name-.jpg
See attached image for better explaination
Name-.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
"[INCIDENT TITLE:]"
Jim.