Type Mismatch using DLookUp

[stampr18]

I am using a dlookup to lookup the product id when the manufacturer and product in the form matches the manufacturer and product in the table. It works fine with just the manufacturer. The type mismatch comes up once I add the And "[Product] part of the code.

Me!ProductID = DLookup("[ProductID]", "TBLProduct", "[Manufacturer]= [FORMS]![FRMORDER].[FRMORDERSUBFORM]!Manufacturer" And "[Product]= [FORMS]![FRMORDER].[FRMORDERSUBFORM]!Product")

 

[stampr18]

Thanks for looking, but I got it.