>>Yes, I did realize it could leave the treeview locked, and in fact did manage to do that initially. I moved some pieces of code around here and there and have it working perfectly now.
>
>THis was a great thread - learned a bunch - but now the question:
>Why did the app require a row lock on the treeview?:-)
This is a Tool Inventory app. All the tools the customer owns are categorized in a 3-level hierarchy. For example an A Frame 10 ft Ladder will be under "Ladders and Scaffolding -> Ladders -> A Frame 10 ft Ladder". Each level is a node in a treeview. They enter transfer records to show where the tool has been moved to, and where it was transferred from. Once they save the transfer, they can only view it, not modify it. Part of that screen shows the tool in its hierarchy in the treeview. There may be enough ladders listed at the same level as "A Frame 10 ft Ladder", but alphabetically before it so that the user can't see the parent node without scrolling up.