Results 1 to 6 of 6
  1. #1
    aligahk06 is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Posts
    94

    Combob box in a form won't display two records with same name

    Dear All,

    i have a combo box in my form for selection of name , but while entering some characters to find out name list from combo box it displayed only one record but under same there is two records available in combo box.



    i want my combo box to display the record in same name sequence.
    eg: if YYY has two records so it should display YYY records in sequence then further records and so on.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    combo boxs ONLY show 1 record. Thats how it works.
    LIST BOX shows many records. Maybe thats the control you want.

  3. #3
    aligahk06 is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Posts
    94
    No,
    it show all records but not in sequence.
    I want to show it in a sequence so that it is easy to find all records with same name.

  4. #4
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Quote Originally Posted by aligahk06 View Post
    No,
    it show all records but not in sequence.
    I want to show it in a sequence so that it is easy to find all records with same name.
    Sounds like you need to add ODRER BY to the SQL statement being used as the Row Source for the combo
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  5. #5
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    In the rowsource query sort by the name field.

  6. #6
    aligahk06 is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Posts
    94
    Done *****

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

Similar Threads

  1. Form not to display the deleted records
    By Shamli in forum Access
    Replies: 1
    Last Post: 08-13-2018, 10:54 AM
  2. How to use a form to display records?
    By xduy in forum Forms
    Replies: 4
    Last Post: 01-13-2017, 11:31 AM
  3. Counting Records to display on Form
    By Ekhart in forum Forms
    Replies: 1
    Last Post: 08-01-2016, 10:13 PM
  4. Replies: 8
    Last Post: 05-10-2015, 06:24 PM
  5. Display ALL records in a form?
    By evander in forum Forms
    Replies: 3
    Last Post: 07-15-2010, 07:59 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