I've reviewed many threads and FAQs about multi-select list boxes, but I can't get to the next step on how to save the values in multi-select for use in queries/reports/form view.
I have a main form - frmClientMain (writes to ClientMain table)
Client_ID can have multiple Type_ID from table Type.
Also, the user can add additional Type fields at any time.
So, in frmClientMain, I want the user to be able to select multiple types from Type.
I tried to add a subform, but it requires ClientMainType table in which Client_ID, Type_ID, Yes/No selection. To have all type selections appear, I would need to populate Client_ID, Type_ID for each new addition of either.
Is this the best way to continue and have code to update ClientMainType upon addition of Client_ID or Type_ID - if so, how do I update. If not, what direction should I head.
Thanks for the help - I'm new at multi select.
I have a main form - frmClientMain (writes to ClientMain table)
Client_ID can have multiple Type_ID from table Type.
Also, the user can add additional Type fields at any time.
So, in frmClientMain, I want the user to be able to select multiple types from Type.
I tried to add a subform, but it requires ClientMainType table in which Client_ID, Type_ID, Yes/No selection. To have all type selections appear, I would need to populate Client_ID, Type_ID for each new addition of either.
Is this the best way to continue and have code to update ClientMainType upon addition of Client_ID or Type_ID - if so, how do I update. If not, what direction should I head.
Thanks for the help - I'm new at multi select.