Treeview automaticly filled with datasource property ?

[alain17]

Hello,


I guess the question has been asked multiple times.
Sorry to ask it once again, but what I found didn't quite meet my request.




I have an Access table called "Category" with the following fields:


N_Category: auto num - identifier of the category (unique key) - long int


Category: category name - string


ParentCategory: contains the N_Category ID of the parent category




Is there a TreeView type hierarchical list control that can be filled in automatically (i.e. without code) by indicating the source table (like a form or a drop-down list to which a table is linked in the "Source property ")?


I couldn't find the source property in the OCX Treeview 6 that came with Access 2016.




If that doesn't exist, I'll write the necessary VBA code, but the first solution would be better ;-)




Thank you !


Alain

[Bob Fitz]

Cross-Posted: https://www.access-programmers.co.uk...t-code.316685/

Please read: https://www.excelguru.ca/content.php?184

[Welshgasman]

He appears to be a serial cross poster as well Bob. Just crossposted two new threads.