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

Posted on 2014-09-02
Last Modified: 2014-09-02
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?
Question by:cssc1
    LVL 56

    Expert Comment

    by:Jim Dettman (Microsoft MVP/ EE MVE)
    Do you really have a colon in your field name?


    LVL 48

    Expert Comment

    by:Gustav Brock
    Or a leading space?

    [ Incident_ID]


    Author Comment

    I learned after developing the application I should not use colon in field names.

    See attached image for better explaination
    LVL 48

    Accepted Solution

    Thus the leading space is your error.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now