Hello, I need a bit of help writing the correct DLookup code. Trying to use two tables.
1. POAgenda
2. BuyerList
I would like to assign the Buyers Name to the PO Agenda table by using DLookup.
My POAgenda has the following columns and column names pulled from a query to apply the DLookup function.
RECORD ASSIGNED
A81
A20
B21
My BuyerList has the following columns and information
QUE BUYER
A81 A81: JOHN DOE
A20 A20: WONDER WOMAN
B21 B21: SUPER BUYER
My code is as follows: ASSIGNED: DLookUp("BUYER","BuyerList","QUE = " & [RECORD]")
I am receiving the following #error in the ASSIGNED field in my POAgenda table where I am trying to put the buyers name.
Any help to get this code correct will be greatly appreciated