现在在窗体下编译到rst.open sql就出错,一直没弄明白错在哪,请各位大侠指教,谢谢Private Sub 确定_Click()
Dim sql As String
Dim rst As ADODB.Recordset
Dim number As Integer
sql = "select * from 商品信息 where"
sql = sql & " [货号]=" & Me![货号列表]
Set rst = New ADODB.Recordset
rst.ActiveConnection = CurrentProject.Connection
rst.CursorType = adOpenDynamic
rst.LockType = adLockOptimistic
rst.Open sql
…………………
Dim sql As String
Dim rst As ADODB.Recordset
Dim number As Integer
sql = "select * from 商品信息 where"
sql = sql & " [货号]=" & Me![货号列表]
Set rst = New ADODB.Recordset
rst.ActiveConnection = CurrentProject.Connection
rst.CursorType = adOpenDynamic
rst.LockType = adLockOptimistic
rst.Open sql
…………………
Me![货号列表]是下拉列表框
我是在access中写的vb语句,不知道哪里有立即窗口啊
控件名要改用英文,中文不习惯
2. Me![货号列表] 的值为 空Private Sub 确定_Click()
Dim sql As String
Dim rst As ADODB.Recordset
Dim number As Integer
sql = "select * from 商品信息 where"
sql = sql & " [货号]=" & Me![货号列表]
msgbox sql
Set rst = New ADODB.Recordset rst.ActiveConnection = CurrentProject.Connection
rst.CursorType = adOpenDynamic
rst.LockType = adLockOptimistic
rst.Open sql
…………………
弹出的msgbox内容为 select * from 商品信息 where 货号=8552
strSql = "select * from 商品信息 where"
strSql = strSql & " [货号]='" & Me.货号列表 & "'"
'如果你确定[货号]字段是文本类型的话,应该前后加单引号'
'Me.货号列表 表示的是你的窗体里名为“货号列表”的控件的当前值'
'而Me![货号列表]有可能会引用到你的窗体的绑定字段'
strSql = strSql & " [货号]='" & Me.货号列表 & "'"
文本类型必須"'"