Dim gx As object 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 If Forms("技术部审核").Controls(nms(i)).value IsNot Nothing If Forms("技术部审核").Controls(nms(i)).Name = "CheckBox1" gx = Forms("技术部审核").Controls(nms(i)).Checked Else gx = Forms("技术部审核").Controls(nms(i)).value End If If filter > "" filter = filter & " And " End If filter = filter & lms(i) & bjf(i) & fgf(i * 2) & gx & fgf(i * 2 + 1) msgbox(filter) End If Next Dim tnm As String = Forms("技术部审核").Name 'Forms("技术部审核").Controls("Table1").Table.filter = filter
|