呵呵,根据错误提示,你的单号应该是数值型,所以:
Filter="單號 =' " & .text & "'"
改为:
Filter="單號 = " & .text
建议看看:
http://www.foxtable.com/help/topics/1284.htm