Doyce,
I'm not sure why your error states "Trailer Description" when this is not in your DLookup("TrailerDesc", "TempVIN") . Are you getting confused by field captions?
Duane Hookom MVP
MS Access (2001-2014)
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Wed, 1 Oct 2014 10:13:27 -0700
Subject: [MS_AccessPros] Dlookup Criteria
Hello Friends,
I'm trying to use DLookUp to return the value in a description field from a temp table where all records will have the same description in the field. Here is what I have DLookup("TrailerDesc", "TempVIN") but I don't know what to put in the criteria. Any record will do. There is a recordID which is the primary key. It is autonumber. I'm getting an error that says "My database cannot find the Trailer Description you referenced in the Object Name argument".
Doyce
I'm not sure why your error states "Trailer Description" when this is not in your DLookup("TrailerDesc", "TempVIN") . Are you getting confused by field captions?
Duane Hookom MVP
MS Access (2001-2014)
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Wed, 1 Oct 2014 10:13:27 -0700
Subject: [MS_AccessPros] Dlookup Criteria
Hello Friends,
I'm trying to use DLookUp to return the value in a description field from a temp table where all records will have the same description in the field. Here is what I have DLookup("TrailerDesc", "TempVIN") but I don't know what to put in the criteria. Any record will do. There is a recordID which is the primary key. It is autonumber. I'm getting an error that says "My database cannot find the Trailer Description you referenced in the Object Name argument".
Doyce
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar