dlookup on query

[molly13]

Hi,

I have the following DLookup as a field in a query, where "Phone Number" is a field in the "Employee Phone Numbers" table, as is [Employee ID]. [ID] is a field in the [EmployeeQuery] that I created (short text). I want to pull up Employees phone numbers based on their ID (i.e., Row 5's Employee ID in the query signals what the row's phone number field should be, based on the Phone Number query), but when I try to view the results, I get a popup that says "Enter Parameter Value" for "EmployeeQuery!ID"

DLookUp("[Phone Number]","Employee Phone Numbers","[Employee ID]='" & [EmployeeQuery]![ID] & "'")

I am very new with Access, and have not done DLookUps before. Could someone please help alert me as to what I am doing wrong?

Thank you very much!!

[pbaldy]

Well, probably

DLookUp("[Phone Number]","Employee Phone Numbers","[Employee ID]='" & [ID] & "'")

but it would be far more efficient to join the phone number table into this query.

[molly13]

That solved it - thank you very much!

And I tried doing that originally, but I must have messed something up, because all of my rows got duplicated by 35 (the number of phone numbers that I have entered).

Thanks again!

[pbaldy]

Happy to help and welcome to the site by the way! If all of your rows got duplicated by the number of records in the second table, you didn't have a join between the tables. In design view, that would be represented by a line between the appropriate fields in each table (the same fields as in your DLookup() criteria).