bomnhauag > 20-06-13, 10:07 AM
s2 = " AND (([formula].[cd_bra]) like '" & "*" & [txt1] & "*" & "')"
s3 = " AND (([formula].[cd_on_for])like '" & "*" & [txt2] & "*" & "')"
s4 = " AND (([formula].[mas_cd]) like '" & "*" & [txt3] & "*" & "')"
s5 = " AND (([formula].[name_product]])like '" & "*" & [txt4] & "*" & "')"
s6 = " AND (([formula].[name_shade])like '" & "*" & [txt5] & "*" & "')"
s7 = " AND (([formula].[date_exp])like '" & "*" & [txt6] & "*" & "')"
s8 = " AND (([formula].[loai_bo])like '" & "*" & [txt7] & "*" & "')"
s2 = " AND (([formula].[cd_bra]) like '*" & [txt1] & "*')"
s3 = " AND (([formula].[cd_on_for]) like '*" & [txt2] & "*')"
s4 = " AND (([formula].[mas_cd]) like '*" & [txt3] & "*')"
s5 = " AND (([formula].[name_product]]) like '*" & [txt4] & "*')"
s6 = " AND (([formula].[name_shade])like '" & "*" & [txt5] & "*" & "')"
s7 = " AND (([formula].[date_exp]) = #" & [txt6] & "#)"
s8 = " AND (([formula].[loai_bo]) = " & [txt7].Value & ")"