主题：[求助]模糊查询

Dim nms() As String = {"TextBox1","TextBox2","ComboBox1","ComboBox2","ComboBox3","ComboBox4","CheckBox1"}
Dim fgf() As String = {"'%","%'","'%","%'","'","'","'","'","'","'","'","'","",""}
Dim bjf() As String = {" Like "," Like "," = "," = "," = "," = "," = "}
Dim lms() As String = {"规格型号","mark","类别_大类","类别_小类","封装_类型","封装_引脚","同意采购"}
Dim filter As String
For i As Integer = 0 To nms.Length - 1  
    Dim gx = Forms("技术部审核").Controls(nms(i)).value
    If gx > "" Then
        If filter > ""
            filter = filter & " And "
        End If
        filter = filter & lms(i) & bjf(i) & fgf(i * 2) & gx & fgf(i * 2 + 1)
    End If
Next