Clearing a Treeview Control

[Frink]

Hallo,

I have a treeview control which I populate from a table, each record is a node. I use "N" & PrimaryKeyField (which is an Autonumber) as the Key for each node.
My problem is how to clear the tree to repopulate it?
I currently use Me!ActiveXCtl0.Nodes.Clear to clear the TreeView control, but when I re-run my populate code, it gives the following error:
35602 Key is not unique in collection
Suggesting that it is trying to add the same key again, although I thought they had all been deleted.
If I close the form and re-open it it populates correctly.

Any ideas?

- Frink

 

[braindead2]

try .remove I also find that it works a lot faster if I do it from the reverse

Private sub Clearnodes
dim nodecount as long
with treeview1.nodes
for nodecount = .count to 1 step -1
.remove nodecount
next
end with
end sub

 

[jhall156]

I find it easiest to create an array of nodes from the data (in my case an interface table showing child parent relationships) and then add those nodes to the treeview nodes collection at run time JHall