Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004

    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.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    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.

  3. #3
    Join Date
    Jan 2007
    Provided Answers: 12
    Change your design, do not store multiple items in a single field.
    Home | Blog

  4. #4
    Join Date
    Nov 2007
    Adelaide, South Australia
    ^ Agreed with that.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    Even though you've said you're going to drive the car over the cliff, here are the keys:;en-us;210203

    In other words, I wouldn't do it either.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts