Hi
I have the following code in my form
Dim varX As Variant
varX = DLookup("[Product Description]", "tblproductlist", "[Product Code] = " & Me!txt_Product)
The expr is correct, there is a field called Product Description in tblproductlist
the table is correct, there is a table called tblproductlist
The field is correct, there is a field called product code in tblproductlist
The me!txt_product is returning the correct data
So why is it giving me the error 2001, which means the syntax is incorrect somewhere i beleive?
thanks in advance
I have the following code in my form
Dim varX As Variant
varX = DLookup("[Product Description]", "tblproductlist", "[Product Code] = " & Me!txt_Product)
The expr is correct, there is a field called Product Description in tblproductlist
the table is correct, there is a table called tblproductlist
The field is correct, there is a field called product code in tblproductlist
The me!txt_product is returning the correct data
So why is it giving me the error 2001, which means the syntax is incorrect somewhere i beleive?
thanks in advance