比如
Filter = "产品型号 = '" & .Value & "'"
改成
Filter = "产品型号 like '%" & .Value & "%'"
http://www.foxtable.com/webhelp/scr/1647.htm