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.
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.
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
3) On the sub-form using a bound combo box with no source, displaying selections in the combo box with multi-level select.
All data is stored in normalized tables. Only the tree leaf selections are stored in the user selections table.
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.
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
3) On the sub-form using a bound combo box with no source, displaying selections in the combo box with multi-level select.
All data is stored in normalized tables. Only the tree leaf selections are stored in the user selections table.