Treeview and Checkboxes

[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

 

[Guest]

Hi,
I fhave figured thos questions...

BR
Markku

 

[ksivam]

Dear MakeLei,
I too am novice to treeview. So how did you extraxt the data from the ticked
checked boxes
thanks
Regards
Ksivam

 

[Guest]

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