Dim WithEvents recordset1 As ADODB.Recordset Dim recordset2 As ADODB.RecordsetPrivate Sub recordset1_MoveComplete(ByVal adReason As ADODB.EventReasonEnum, ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset) On Error GoTo MoveComplete_Error recordset2.AbsolutePosition = recordset1.AbsolutePosition Exit Sub MoveComplete_Error: End Sub
Set adoPrimaryRS = New Recordset adoPrimaryRS.Open "SHAPE {select * from 客户档案} AS ParentCMD APPEND ({select * from 客户档案 } AS ChildCMD RELATE 用户号 TO 用户号) AS ChildCMD", adoConnect, adOpenDynamic, adLockOptimistic Dim oText As TextBox '绑定文本框到数据提供者 For Each oText In Me.txtFields Set oText.DataSource = adoPrimaryRS Next '绑定到datagrid Set grdDataGrid.DataSource = adoPrimaryRS两者可以同步变化
Dim recordset2 As ADODB.RecordsetPrivate Sub recordset1_MoveComplete(ByVal adReason As ADODB.EventReasonEnum, ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)
On Error GoTo MoveComplete_Error
recordset2.AbsolutePosition = recordset1.AbsolutePosition
Exit Sub
MoveComplete_Error:
End Sub
adoPrimaryRS.Open "SHAPE {select * from 客户档案} AS ParentCMD APPEND ({select * from 客户档案 } AS ChildCMD RELATE 用户号 TO 用户号) AS ChildCMD", adoConnect, adOpenDynamic, adLockOptimistic Dim oText As TextBox
'绑定文本框到数据提供者
For Each oText In Me.txtFields
Set oText.DataSource = adoPrimaryRS
Next
'绑定到datagrid
Set grdDataGrid.DataSource = adoPrimaryRS两者可以同步变化