ardy
Registered User.
- Local time
- Yesterday, 23:29
- Joined
- Sep 24, 2012
- Messages
- 98
Hello All,
I am trying to pull a number(Not string) from a form I am working on. I think my issue is syntax but can't figure this out and I have tried several version all ending up in #Error
Domain = Access_Agreement
expression = APN (number)
criteria = lookup from a field from the form (Well_ID is String)
I have pretty good feeling the issue is in the syntax of the criteria, but can't nail it down. Any help is appreciated.
Here is what I have tried so far.
Ardy
I am trying to pull a number(Not string) from a form I am working on. I think my issue is syntax but can't figure this out and I have tried several version all ending up in #Error
Domain = Access_Agreement
expression = APN (number)
criteria = lookup from a field from the form (Well_ID is String)
I have pretty good feeling the issue is in the syntax of the criteria, but can't nail it down. Any help is appreciated.
Here is what I have tried so far.
Code:
=DLookUp("APN","Access_Agreement","Well_ID = & [Forms]![Facility_Details]![Well_ID])
=DLookUp("APN","Access_Agreement","Well_ID = '" & [Forms]![Facility_Details]![Well_ID]"'")
=DLookUp("APN","Access_Agreement","Well_ID = & Me.Well_ID")
Ardy