I am trying to get the surnames of customers to populate based on the selected product groups, product models and first names. The expression below results in #name? error. What did I do wrong?
Please note that I do not have a primary key in the query. I only have unique records.
Please note that I do not have a primary key in the query. I only have unique records.
Code:
DLookup("[Surname]", "[query]", "[Product Group] ='" & Forms![Add Product Info]![Product Group] & "' AND [Product Model] ='" & Forms![Add Product Info]![Product Model] & "' AND [First Name] ='" & Forms![Add Product Info]![First Name] & "' ")