Treeview and Checkboxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I am using the first time Treeview (and checkbox in each line) in Access. I
have been able to figure out with example how it is done. Now I have a
question; How can I get data of the selected items in Treeview (where
checkbox is activated with a tick)? Any help is appreciated.

BR
MakeLei
 
Dear MakeLei,
I too am novice to treeview. So how did you extraxt the data from the ticked
checked boxes
thanks
Regards
Ksivam
 
Hi ksivam,
Sorry for late answer, here we go... This is the main part of the code:
Dim i As Integer
Dim strSel As String
Dim lngSel As Long

If xTree.Nodes.Count > 0 Then
For i = 1 To xTree.Nodes.Count
If xTree.Nodes(i).Checked = True Then
strSel = strSel & "([YourTable].[YourColumn]) Like ""*" &
xTree.Nodes(i) & "*"" OR "
Else
End If
Next
End If

......
Error trapping and other is same as usual.

BR
Makelei
 
Back
Top