access TreeView Control Problem

[hascons]

Hello,

I am having problems getting a third level with a treeview control on a form. I can get 2 levels but I seam to be missing something.

I've attached a sample access database with just 1 form and a couple of tables and queries.

I'm hoping to be able to take the selected 3rd level node and transfer the last three fields(from the recordset)that the node represents to a subform.

Any help would be greatly appreciated.

hascons

 

[jdraw]

I don't have acc2007. Here is a link to a blog that has been useful in the past.

http://mytreeviewblog.blogspot.com/