jbrown2339
Technical User
I'm trying to build a series of forms to walk an individual with little computer skills through some tables to look up some information. The table I am building these forms on has around 181,000 records in it, each of which identifies a unique customer.
I created two forms for him to look at information on these customers by their customer ID or by their name. I then used a combo box to aid him in pulling up customer id or name by displaying possible values (in case of typos in the source table). I've done this before for some other data, and it always worked fine. But never with this many records.
In this case, the combo boxes are not displaying all the values of those records. For instance, on the one that sorts by name, the combo box only goes up to the HA's, and then after that shows null values. It doesn't end at Ha, you can still scroll down past that, so it's not like there is a recordlimit or anything. But as you scroll down, it just shows blank data. It also always stops at the same place (i.e. whenever I open the database, the last record is always the same, not like it is a memory issue or it is still loading records which would probably cause it to be different every time). Also, if I select a specific record # from the bottom of the form (down by the arrows at the navigation section), it will pull up customers in the Z's, Y's, etc. So the form will pull up the record #'s that are in the null section of the combo box display. Finally, the last record displayed is different between the customer ID and the customer name. For customer ID the combo box stop displaying values at the 63,536th record, and the customer name form combo box stops at the 75,722nd record, so it's not consistent between each combo box (i.e. a built in Access recordlimit for combo boxes). These are also combo boxes on two different forms, so they aren't connected or interefering with each other.
I just can't figure out why they would always stop at those two points, and why they won't display the rest. The space is still there to scroll through, it's just null space. Does anyone have any ideas? I've been racking my brain to figure this out. Thanks!!
I created two forms for him to look at information on these customers by their customer ID or by their name. I then used a combo box to aid him in pulling up customer id or name by displaying possible values (in case of typos in the source table). I've done this before for some other data, and it always worked fine. But never with this many records.
In this case, the combo boxes are not displaying all the values of those records. For instance, on the one that sorts by name, the combo box only goes up to the HA's, and then after that shows null values. It doesn't end at Ha, you can still scroll down past that, so it's not like there is a recordlimit or anything. But as you scroll down, it just shows blank data. It also always stops at the same place (i.e. whenever I open the database, the last record is always the same, not like it is a memory issue or it is still loading records which would probably cause it to be different every time). Also, if I select a specific record # from the bottom of the form (down by the arrows at the navigation section), it will pull up customers in the Z's, Y's, etc. So the form will pull up the record #'s that are in the null section of the combo box display. Finally, the last record displayed is different between the customer ID and the customer name. For customer ID the combo box stop displaying values at the 63,536th record, and the customer name form combo box stops at the 75,722nd record, so it's not consistent between each combo box (i.e. a built in Access recordlimit for combo boxes). These are also combo boxes on two different forms, so they aren't connected or interefering with each other.
I just can't figure out why they would always stop at those two points, and why they won't display the rest. The space is still there to scroll through, it's just null space. Does anyone have any ideas? I've been racking my brain to figure this out. Thanks!!
