Treeview Value stored to a Table

[smbarney]

I have looked at a lot of treeview examples and none of them do what I need. Basically, I want a user to able drill down to a specific office using a treeview. That office would then be stored in the tblMain under the "location" field.

The treeview should be based on the table "tblLocations" which has the following structure:
Region
District
Office

Each office has a unique id. I was thinking that I could use a pop up form and have the user select the location in the pop up. However, I cannot figure out how to store that information selected by the user. Thanks.

 

[MarkK]

I'd store the user's selection using an update query, or maybe a recordset for clarity if there are a lot of fields. I don't see how it matters that the data comes from a tree view. Is it that you don't know how to determine what the user selected?