tbl.filter = "(pfullname Like " & txt & " Or Standard Like " & txt & " Or Unit1 Like " & txt & ") and (leveal=2 and deleted=0 and isstop=0 ) " t.Sort = "pfullname desc,standard desc,unit1 desc"
参考:
http://www.foxtable.com/help/topics/0451.htm