I got a product table, in this product table is a supplierfield. This field is a multi value field. Now i got a dlookup in my orderform. So when a product is put in it looks the supplier up. Now i got a error with my code:
I guess the dlookup function can only search for one value. Is there a dlookup function for multi value's?Code:ComboBoxSupplier = DLookup("[Product_SupplierID]", "tblProduct", "[ProductID]=" & [ComboBoxProduct])