The TreeView control reports its current node–the selected node–only in its NodeClick event’s Node parameter. If you need to access the Node’s properties–such as Key or Text–outside this event, you need to declare a Node variable with scope appropriate to your intended usage. To share within a form, include a variable declaration in the Declarations section:
Option ExplicitPrivate CurrentNode As node
Set your variable–in this illustration, CurrentNode–to the node passed in the event:
Private Sub tvwDB_NodeClick(ByVal node As node)Set CurrentNode = node
You can now access CurrentNode’s properties from anywhere on the form:
Debug.Print CurrentNode.KeyDebug.Print CurrentNode.Text