I have been trying to add multiple criteria to a dlookup and cant get the syntax correct. CodeOn hand FG: DLookUp("ML_QTY","ML","[ML_IMKEY] = '" & [IM_Key] & "' and ML_LOCATION like 'B-*'") I need to add ML_LOCATION = 'FG' how do I add that?