Results 1 to 6 of 6
  1. #1
    NightWalker's Avatar
    NightWalker is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2016
    Location
    Midwest USA
    Posts
    253

    ComboBoxes all changing to same value

    I have a form I am currently developing that has 25 comboboxes all named differently (cboQA1....cboQA25). they are for an answer of yes or no. I tried to first have the table as a yes/no and the format of the cbo as yes/no. that kept giving me errors that I don't remember . so I changed the table field to text and tried to get that to work but I couldn't get the yes /no to show up as selectable answers. I created a new table with 2 fields (ID, Response) the original table I changed the field to a long integer and set it to store the ID of the new field. now it all started working until I added the 2nd thru 25th cbo boxes to the form. Now when I change any of the cbo boxes they all change to the same answer. I have no code written yet for any cbo after the 2nd one yet. This has me very confused.




    Could someone please help me?

    Thank you all in advance

    Walker

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Sounds like they are all bound to the same field, which would happen if you copied the first.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    NightWalker's Avatar
    NightWalker is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2016
    Location
    Midwest USA
    Posts
    253
    Yes they are all bound to the same field because they are the responses to 25 different questions. How can I make this work. I have been messing with this for 3 days now and haven't moved forward.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    If they are 25 different responses, you'd need 25 fields. Perhaps Duane's sample will help:

    http://www.rogersaccesslibrary.com/forum/topic3.html
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    NightWalker's Avatar
    NightWalker is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2016
    Location
    Midwest USA
    Posts
    253
    Well I went and talked to the people needing the database and got them to all me to change the way they input the responses to the data. I can have a form with a question box and a answer box and just loop through the questions. the report will be the same as they wanted originally but outputting the data will be much simpler. Thank you for the link and letting me know WHY they were all changing together.

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No problem.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Dependent ComboBoxes
    By HansJ in forum Forms
    Replies: 3
    Last Post: 06-09-2016, 05:12 PM
  2. Replies: 3
    Last Post: 03-31-2016, 12:16 PM
  3. Comboboxes go where?
    By PaulCW in forum Database Design
    Replies: 12
    Last Post: 10-04-2011, 02:34 AM
  4. Subform with Comboboxes
    By Angate in forum Forms
    Replies: 5
    Last Post: 04-23-2010, 08:10 PM
  5. How to Reset Comboboxes
    By bbarrene in forum Programming
    Replies: 5
    Last Post: 01-23-2010, 11:11 PM

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