Results 1 to 9 of 9
  1. #1
    koncreat is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2015
    Location
    U.S.
    Posts
    43

    combo box not listing all vaules

    I have a form that prompts a user to select a value from a combo box and that value is used to run a report. The problem i have is the combo box is only showing the first value from the linked table and wont let me select any other value. I am able to use the record navigator at the bottom and scroll through the values but that isnt very efficient.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    if the combo source connected to a query/table that has 12 records, then the combo should show 12 records, if
    the combo target is bound to a field,
    the combo is not locked
    the combo is storing the correct column
    the form query allows you to modify data

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  4. #4
    koncreat is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2015
    Location
    U.S.
    Posts
    43
    The combo box points to a table that has only one row and column for the combo box data.
    Attached Thumbnails Attached Thumbnails reletionships.JPG  

  5. #5
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    one other to add to Ranmans list

    The combo rowsource is not bound to a unique id e.g. bound to first column

    FirstName...LastName
    John...........Brown
    John...........Smith

    will always choose John Brown

  6. #6
    koncreat is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2015
    Location
    U.S.
    Posts
    43
    The table for the combo box is in this format:

    Name
    John Smith
    John Doe

    No other columns are in the table.

  7. #7
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    So when you click on the Combo box, there is only 1 name in the list that shows? If so is the combo box based directly on a table or on a query of that table and if a query, are their any conditions to prevent all names to appear?

  8. #8
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    The table for the combo box is in this format:

    Name
    John Smith
    John Doe

    No other columns are in the table.
    OK so a single column - your column count is 1 and the bound column is 1.

    I would go back to Ranmans suggestions and answer them

  9. #9
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Let's look at this another way.

    What are you using the combo box for? If you are using it to select a value that is used to run a report, then the combo should be unbound, i.e. the Control Source property for the combo box will be blank.

    In your original post, you said:

    I am able to use the record navigator at the bottom and scroll through the values
    which to me indicates your combo box is (wrongly) bound to a table field.

    Now, what is the Row Source property for the combo box? Normally it is the name of a table or query, or it can be SQL Select statement.

    In post #4 you wrote:

    The combo box points to a table that has only one row and column for the combo box data.
    If the table that is the Row Source for the combo box only has one record in it, then the Combo Box will only have one row in the list - that's how combo boxes work.

    Can you clarify some of these for us?

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

Similar Threads

  1. Replies: 6
    Last Post: 09-22-2015, 10:36 AM
  2. Replies: 4
    Last Post: 12-12-2013, 09:13 PM
  3. Replies: 1
    Last Post: 09-01-2013, 09:44 PM
  4. Replies: 1
    Last Post: 03-23-2012, 01:22 PM
  5. Replies: 3
    Last Post: 03-23-2012, 06:16 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