I have a tree view built into a form when i refresh the form data everything refreshes except the treeview control to do this i have to close the from then reopen it - any ideas how this can be done without closing and reopening

Try:

ctlCombo.Requery

Type "requery control" in the Help box in the VBA window for more info.



mmcdonal

I have tried what you suggested and several variations but to no effect. the Treeview control is populated by a fill function that uses some 50+ querries to populate the treeview the code is similar to the code found in "expert one-to-one" Access Development by Helen Feddeman.

Many thanks i have tried that but no luck the tree view control is populated by 50+ querries when the form loads is there a way to unload and reload with uptodate data?

I have now resolved the problem - me.treviewname.nodes.clear removes all the nodes then - me.treeviewname_fill puts them back with the updated data.

Hey, just wanted to "Thank you" for posting your solution - not everybody does - it really helped me with my problem.