DBLookup Failure

Posted on 2009-12-21
Last Modified: 2013-12-18
I continue to struggle with @DBLookups. Have form which has a subform which has a number of contact by business line. I have a form that has all the contact and am not able to get it to pull the value. Field is a computed names field. poc is the view, agency_num is the field that it looks to which is on the same form that the field are embedded into. Trying to pull the value from column 2. What am I missing here.
@DbLookup("": "NoCache";"";"poc";"agency_num";2;[FailSilent])

Open in new window

Question by:jforget1
    LVL 19

    Expert Comment

    In the view "poc", make sure the first column is sorted.
    LVL 19

    Expert Comment

    Also, I suggest to use below and see what error it populates.
    @DbLookup("": "NoCache";"";"poc";"agency_num";2)
    Once the above is successfull, then u can use your code or a combination of @ISError
    LVL 13

    Accepted Solution

    You're now lookup for a value "agency_num"; NOT is value!
    Try again after removing the quotes around the fieldname.

    Author Closing Comment

    Appreciate the help.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
      In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    728 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

    17 Experts available now in Live!

    Get 1:1 Help Now