jeffmoseler
Well-known Member
- Joined
- Jul 16, 2004
- Messages
- 540
I have this dlookup in a query field and it is not working.
I know it is just a matter of syntax, but I can't figure out what I have done wrong. The error keeps telling me it can't find "ItemListID". This query is in the row source of a listbox by the way, not in the queries section of the database. I have a feeling that has something to do with it since the query doesn't really have a name.
Also here is the SQL view:
SELECT RunSheetTable.RunSheetID, RunSheetTable.OrderQueryItemID, ItemListID, DLookUp("ItemNum","ItemList","ItemListID =" & [ItemList]![ItemKey]) AS Expr1
FROM ItemList INNER JOIN (RunSheetTable INNER JOIN OrderDataQuery ON RunSheetTable.OrderQueryItemID = OrderDataQuery.Key) ON (RunSheetTable.ItemListID = ItemList.ItemKey) AND (ItemList.ItemNum = OrderDataQuery.Item);
Thanks for the help!
Code:
=DLookup ( "ItemNum" , "ItemList" , "ItemListID =" & [ItemList]![ItemKey])
I know it is just a matter of syntax, but I can't figure out what I have done wrong. The error keeps telling me it can't find "ItemListID". This query is in the row source of a listbox by the way, not in the queries section of the database. I have a feeling that has something to do with it since the query doesn't really have a name.
Also here is the SQL view:
SELECT RunSheetTable.RunSheetID, RunSheetTable.OrderQueryItemID, ItemListID, DLookUp("ItemNum","ItemList","ItemListID =" & [ItemList]![ItemKey]) AS Expr1
FROM ItemList INNER JOIN (RunSheetTable INNER JOIN OrderDataQuery ON RunSheetTable.OrderQueryItemID = OrderDataQuery.Key) ON (RunSheetTable.ItemListID = ItemList.ItemKey) AND (ItemList.ItemNum = OrderDataQuery.Item);
Thanks for the help!