从语句上看,交易单号应该是字符型,但从流程上看,交易单号往往是数值型,所以确认交易单号的类型,如果是数值型,语句改为:str = str & "[交易单号] = " & Me.Combol & " AND "
