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

DBLookup Failure

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

0
jforget1
Asked:
jforget1
  • 2
1 Solution
 
madheeswarCommented:
In the view "poc", make sure the first column is sorted.
0
 
madheeswarCommented:
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
0
 
CRAKCommented:
You're now lookup for a value "agency_num"; NOT is value!
Try again after removing the quotes around the fieldname.
0
 
jforget1Author Commented:
Appreciate the help.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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