|
求助!ADO绑定主子窗体,主、子窗体链接字段无用了!
先谢谢了!
如题:就是说主窗体与子窗体不能互动了。如不用ADO绑定,就可以正常用使用了
Dim rec As New ADODB.Recordset
Dim rec1 As New ADODB.Recordset
rec.CursorLocation = adUseClient '绑定主表
rec.Open "表1", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
Set Me.Recordset = rec
rec.Close
Set rec = Nothing
rec1.CursorLocation = adUseClient '绑定子窗体表
rec1.Open "表2", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
Set Me.表2子.Form.Recordset = rec1
rec1.Close
Set rec1 = Nothing
求大侠们相助,谢谢了!!!!!! |
|