Results 1 to 3 of 3
  1. #1
    user622 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2011
    Posts
    6

    multi-select listbox and new entry button

    I am creating a data entry form to answer a questionare. the question id and question are on the master form while the answer (combobox with true, false, n/a) comments (textbox) location (multi select list box with source from another table) and year (textbox)

    i need help with 2 things

    1. I would like the code for to make new entries in the table for each option selected in a multi-select box that keeps all the answers in the other fields on the form.(I dont know VBA myself so any help in that area is helpful)

    2. if possible, a button that would create the new entries and then clear the subform for more data entry without going to the next question.



    Again, i dont know any VBA myself so i would need the code to either be given or linked to me. Im new to access and i appologize for any misinturpretations or incorrect names for things.

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    this has viewed a number of times: http://www.access-programmers.co.uk/...light=list+box

    he's a good guy, and knows what he's doing. I would not do it the way he did, but there is nothing wrong with his method. I would look at that.

  3. #3
    user622 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2011
    Posts
    6
    Thanks, it was helpful and explained what i need the code to do and how it will work, but as i stated befor, i dont know anything about vba so unless all i have to do is change the name of objects or references, I wont be able to get much out of it.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 11-24-2014, 02:11 PM
  2. Replies: 3
    Last Post: 06-22-2011, 08:51 AM
  3. Multi select list box
    By foxtet in forum Forms
    Replies: 1
    Last Post: 05-30-2011, 02:13 PM
  4. Multi select box with several options
    By float in forum Programming
    Replies: 7
    Last Post: 10-04-2010, 07:33 AM
  5. Multi-select listbox and update flag in table
    By Suresh in forum Programming
    Replies: 0
    Last Post: 12-19-2007, 01:04 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums