加上。
if rs1.state=adstateopen then
rs1.close
end if
rs1.open "select distinct Con_Name from wideband_busin where Con_Name='" & Trim(Combo1.Text) & "'",cn,3,1
这样就可以保证每次都可以刷新你的记录了~~~~~~~
if rs1.state=adstateopen then
rs1.close
end if
rs1.open "select distinct Con_Name from wideband_busin where Con_Name='" & Trim(Combo1.Text) & "'",cn,3,1
这样就可以保证每次都可以刷新你的记录了~~~~~~~
Private Sub Form_Load()
Set cn = New ADODB.Connection
With cn
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\wideband\data\宽带.mdb;Persist Security Info=False"
.Open
End With
Set rs = New ADODB.Recordset
With rs
.CursorLocation = adUseClient
.CursorType = adOpenDynamic
.Open "select * from wideband_busin ", cn
End With
Do While Not rs.EOF
Combo1.AddItem rs.Fields("Con_Name")
Combo2.AddItem rs.Fields("Serve_Name")
rs.MoveNext
Loop
End Sub
Dim cn As ADODB.Connection
Dim rs As ADODB.RecordsetPrivate Sub Form_Load()
Set cn = New ADODB.Connection
With cn
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\wideband\data\宽带.mdb;Persist Security Info=False"
.Open
End With
Set rs = New ADODB.Recordset
With rs
.CursorLocation = adUseClient
.CursorType = openkeyset
.Open "select * from wideband_busin ", cn
End With
Do While Not rs.EOF
Combo1.AddItem rs.Fields("Con_Name")
Combo2.AddItem rs.Fields("Serve_Name")
rs.MoveNext
Loop
End SubPrivate Sub Combo1_Click()
On Error GoTo wrong
Dim aa As String
Dim cn1 As ADODB.Connection
Dim rs1 As ADODB.Recordset
If Trim(Combo1.Text) <> "" Then
aa = "select distinct Con_Name from wideband_busin where Con_Name='" & Trim(Combo1.Text) & "'"
End If
Set cn1 = New ADODB.Connection
With cn1
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\wideband\data\宽带.mdb;Persist Security Info=False"
.Open
End With
Set rs1 = New ADODB.Recordset
with rs1
.CursorLocation = adUseClient
.CursorType = openkeyset
.Open aa, cn1
Form3.Show
Form2.Hide
Exit Sub上面的代码在你的基础上修改过了,你试试
祝你好运…!!!
wrong:
MsgBox "请选择相应字段 ", vbOKOnly + vbInformation, "提示"End Sub
private sub 事件()
msgbox "事件名"
end sub
如果用datacombo应该没有这么多烦事
我的Rs1应该有读取数据啊
可是我的目的就是要从一个窗体引入另一个窗体啊,若去掉一个窗体这样有何意义呢各位高手们麻烦你们了,再给小弟一些意见吧,我解决这个已经搞了20多天,将近一个月了,可是还没解决出来啊,谢谢了
用Adodc控件不好吗?
那样只要几行代码就行了啊
我刚做了跟你的有点类似的东西
可我用的是控件
你那么多代码我看的头直晕
看每次变化COMBOX 是SQL的变化是不是正确再 FORM2。HIGH后加上
SET RS1=NOTHING
UNLOAD FORM3
你好,我按这样做,但它说 DubeG 无效或不符合引用啊
第二,没有发现你怎么把查询结果显示在第二个窗体里的,你查查这方面的语句
例如:你的FORM2的FORMLOAD中做了一些处理,当你调用它SHOW时,它又一次地执行了FORMLOAD,这样有可能改变你的显示内容。具体你可单步调试。
原因在于第二个窗体上!!!
另外,这种问题只能用单步跟踪的方法,看看程序执行的过程。