以下是引用有点甜在2014-9-22 11:49:00的发言:
参考代码
If e.Table.Current Is Nothing Then Return
For Each ra As Relation In Relations
If ra.ChildTable.Name = e.Table.Name Then
Dim filter As String = ""
filter = ra.ParentColumn.Name & " = '" & e.Table.Current(ra.ChildColumn.Name) & "'"
Dim r As Integer
r = Tables(ra.ParentTable.Name).FindRow(filter)
If r >= 0 Then '如果找到的话
Tables(ra.ParentTable.Name).Position = r '定位到找到的行.
End If
End If
Next
如果反过来,即返回父表的对应行,当前表是父表的时候,返回子表的时候也能够找到对应行就更好。我测试了,但就是自动关闭软件