Dim s As String
Dim trv As WinForm.TreeView = e.Form.Controls("TreeView1")
For Each nd As WinForm.TreeNode In trv.AllNodes
If nd.level = 1 andalso nd.Checked Thene.Form.DropDownBox.Value = nd.Text
for each a as WinForm.TreeNode In nd.AllNodes
If nd.Checked Then
s = s & "," & a.Text
End If
next
tables("表A").current("第二列") = sexit for
End If
Next
e.Form.DropDownBox.CloseDropdown