How to check if a node of a tree exists

[weekend00]

I have a tree (Microsoft treeview control), I create the nodes with keys equal to a key field in my table.



My question is: in VBA, how do I test if a node with specified key exists? for example, I want to know if the node of key "T1024" is already created in the tree. When I use treeview.nodes("T1024").text="" or isempty(treeview.nodes("T1024")), it just pop an error when the node is not exists.

what I can do now is use ON ERROR to trap it, if error is raised, then I think the node is not exists.

is there a beter to test the existance of a node?

[NTC]

well in the db point of reference the key is "equal to a key field in my table".

If a value is (may be) in a table then one can always determine if it exists with a DLookUp method.

As to treeview though I really don't know anything about that. But hope this helps a little.

[weekend00]

I can find it in the table, what I want to do is:
I find a key in the table, then check if the key is in the tree, if is, show the node, is not, add a node.