Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Kansas, USA
    Posts
    73
    Thanks
    0
    Thanked 0 Times in 0 Posts

    pull down combo (A2000 SR-1)

    Is there a limit to how many records can populate a drop-down combo box? I have a database with about 130,000 records that have a 7-digit numeric primary key and the lookup drop down box only goes to about 90 some thousand records. It won't go to the bottom in the drop down box. If you type in the full number it will pull that number up on the form, but with the dropdown box dropped down--it just won't go there.

  2. #2
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: pull down combo (A2000 SR-1)

    Gary
    Not sure if you can do something with this, but it deals with combo's and many thousands of records.
    Attached Files Attached Files

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: pull down combo (A2000 SR-1)

    See ACC2000: Combo Boxes Limited to 65536 (64 KB) Rows. A combo box with 130,000 item would be madness anyway.

    A better approach is to use cascading combo boxes. Let the user select a category in the first one, a subcategory in the second one, etc.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: pull down combo (A2000 SR-1)

    The max is large, but not that large. Combobox performance with over 100 rows is very poor anyhow, and pity the poor user who has to find anything in it.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •