我程序代码如下
For j = 1 To 30
If Rs.State Then Rs.Close
Str = "SELECT * from Table_RowPlace where Cmb & " & j & "='" & CmbTxt & "'"
Rs.Open Str, Cn
If Rs.EOF = True Then aaa = 1
Next j想要的结果是希望WHERE条件为 cmb1="",cmb2=""......cmb30=""但现在字符连接不成功每次都是cmb & 1="" ,cmb & 2 =""...... cmb30=""有什么方法改正吗?
For j = 1 To 30
If Rs.State Then Rs.Close
Str = "SELECT * from Table_RowPlace where Cmb & " & j & "='" & CmbTxt & "'"
Rs.Open Str, Cn
If Rs.EOF = True Then aaa = 1
Next j想要的结果是希望WHERE条件为 cmb1="",cmb2=""......cmb30=""但现在字符连接不成功每次都是cmb & 1="" ,cmb & 2 =""...... cmb30=""有什么方法改正吗?
If Rs.State Then Rs.Close
Str = "SELECT * from Table_RowPlace where Cmb" & j & "='" & CmbTxt & "'"
Rs.Open Str, Cn
If Rs.EOF = True Then aaa = 1
Next j