Multi-value field (MVF) using tree control (2 Viewers)

RonPaii

New member
Local time
Today, 01:48
Joined
Jul 16, 2025
Messages
25
Attached is a sample database that emulates MVF using MS common control Tree Control "MVF_Control_Tree". It works in both x32 and x64 bit Access. It has the added benefit of supporting multiple levels of grouping of the available selections. The sample "frmUsers" opens when you open the database, demonstrating 3 methods of opening the "MVF" form and displaying the user selections using both single level and multi-level selection lists.

1754505345589.png

1) On the main form using an un-bound combo box, displaying selections as comma separated text in the combo box with single level selection.
1754505471427.png

2) On the main form, using an un-bound combo box, displaying selections in a sub-form "subFrmSelected" with multi-level select.
Color:
Blue: current row
Cyan: all selections in group are checked
Yellow: at least 1 selection in group is checked
White: un-checked
1754505607774.png

3) On the sub-form using a bound combo box with no source, displaying selections in the combo box with multi-level select.
1754505943203.png


All data is stored in normalized tables. Only the tree leaf selections are stored in the user selections table.

1754506478182.png
1754506538025.png
 

Attachments

Users who are viewing this thread

Back
Top Bottom