Results 1 to 6 of 6
  1. #1
    107295 is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2011
    Posts
    3

    Angry Help with combo boxes?

    So basically, I'm making a school test grading system as a project. Everything works fine except one thing: one of my forms is a "Results" form, where test results for each student is stored. I'm trying to make a combo box instead of simply inserting the field "TestName" so that you can select tests from a list instead of typing it in.



    I already have a TestTable with all the test names and unique Test Numbers, and it is linked to the results table already. When I make the combo box with the wizard, I say to look in the TestTable for the TestName. It is all fine up to here. When I try to test it and choose a value from the list, ALL the records underneath it (test data) have a Test Name of what I just chose. How do I make these independent?

    If it helps, the form itself contains Student details while a subform contains all the information for the tests.

    If you need any more information that I may have missed out, please do tell me.

  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
    It sounds like the combo does not have a control source, which should be a field in the table.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    107295 is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2011
    Posts
    3
    Quote Originally Posted by pbaldy View Post
    It sounds like the combo does not have a control source, which should be a field in the table.
    Would adding a control source fix the replication?

  4. #4
    thhui is offline Competent Performer
    Windows XP Access 2002
    Join Date
    Feb 2009
    Posts
    235
    It seems that the combo box test field has tied with the underlying subform test fields.
    You should check out that this link should not be existed.

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Quote Originally Posted by 107295 View Post
    Would adding a control source fix the replication?
    It should; what purpose would the combo serve if the selection wasn't saved?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  6. #6
    thhui is offline Competent Performer
    Windows XP Access 2002
    Join Date
    Feb 2009
    Posts
    235
    The combo box control source should be linked to some outside table with distinct values of Test Names.

    You can use a query to generate this new table and make it the control source of the combo box.
    Last edited by thhui; 02-09-2011 at 06:48 AM.

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

Similar Threads

  1. Combo Boxes
    By Duncan in forum Access
    Replies: 9
    Last Post: 10-26-2010, 08:45 PM
  2. Combo boxes
    By Nixx1401 in forum Forms
    Replies: 1
    Last Post: 07-19-2010, 06:07 AM
  3. combo boxes
    By thewabit in forum Forms
    Replies: 7
    Last Post: 01-01-2010, 08:51 PM
  4. combo boxes
    By googenfrog in forum Forms
    Replies: 3
    Last Post: 07-03-2009, 05:41 PM
  5. combo boxes
    By labrams in forum Forms
    Replies: 0
    Last Post: 04-20-2006, 09:28 AM

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