Refresh Treeview on UserForm

I have a treeview on userform and when you open no items are selected on tree,once you click a item its highlighted.I want to have a command button
to set the tree back to the way it opens with no selected item.I can do it by unloading and loading form but must be better way.This code does not work ,not
sure if a tree can be refresh to open state after a item has been selected. Maybe some ideas

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hello cytop
Gave it a try and no luck,item stays highlighted.

Works for me... Do you have any other code in a NodeClick (or other event that might b fired) for the Treeview?

You are correct cytop
have some other code to fix,this might take me some time.

Really need expert help,can't find way to take focus off list index when something is typed in search box.I want when
you type a letter in search box the list index has nothing selected except search results.When you click to clear the
search box there is no items selected and the textbox is blank like when form opened.

Thanks Andy

Is there a way that set the form back to when it opens state when a letter is typed in search box? When you first open form nothing is selected and no text in textbox1. Maybe
this is not possible.

I'm little slow Andy but I will get this.LOL
Can you reset form when you enter searchbox everything is like userform has been loaded for first time.

Thanks Andy
After many hours of trying, and searching on google has got me no where.I guess I can stay with unload,load to make it work.Wish the
userform did not show changes when re loading.

Hello Andy
This is getting so close,the only problem is when I enter the search box it deletes the data in the node that was selected. Need to get the textbox to default back to
stage when the form Initialize. I added label2.caption to the code so it disappears when you enter search box.Have to find a way to clear textbox and not delete data
from its database.

Hello Andy Again
This thing is so close,here is a way I found around the problem.I added some code that just hides the data in textbox,seems to
work but not sure if its the best way. here is what I added.

Please Login or Register  to view this content.

Please Login or Register  to view this content.