Unanswered: How to use multi select items in access
I have a field called brochures. I would like user to have the ability to select multiple brochures and save all these brochure in one field (text field). As in this database, i don't need to have another table to store the brochures. So only one field in the table to store all the brochures the user select. Could you please help me? Thanks in advance.
it would be a heck of a lot easier to store the brochures associated with a customer or supplier or whatever as a single association per brochure. but if you insist on going down the orute you have chosen then so beit.
you need to place some code in the form which decodes your stored values into the mulit select box.. that means programatically manipulating the list box, called probbaly int he forms on current event.
you need a mechanism to recode the users selections int he forms before update event. that is the reverse of the set process. you iterate through the listboxes set itesm and stroe them as requried in your data.
personally I think whjat you are proposing sucks.. its a pig to maintain, you are going to have problems over time, as you have lost the realtional integrity between a brochure and where its used, you don't have the ability to (easily) identify if say customer X has received/been sent brochure Y.