Limited List Rows in Distinct Row query

geraldcor

Registered User.
Local time
Today, 23:43
Joined
Jan 26, 2004
Messages
145
Hello,
On a form I have a way to search for a record by using a listbox that has a Distinct Row Query from the table that the main table that the form is bound to. It looks for the Sample ID's that are associated with the samples that we test. The list ends at record 87877. We are WAY past that number in our numbering scheme but the list box does not display all the records. When the users type anything over 87877 the auto complete doesn't work and the last record shown in the list is 87877. Does anyone have any idea how to make all records show? The users use this to navigate quickly between samples but now it is broken. Is there some sort of limit?
Thanks
Greg
 
What number does your sample ID start with? 87,877 seems like you are at the limit of the list box capabilities. You should come up with a way to narrow down the choices, like coming up with a combo box or other list box to limit based on something like:
0-19,999
20,000-39,000
etc.
 
That seems a bit absurd that there is a limit on list boxes but your suggestion is good. I will do that. Thanks.
 
i vaguely recollect now that a list box/combo box has an upper limit of total characters it can handle, so presumably you have hit this.

A large list box is not necessarily effective anyway - what are you trying to find in it - perhaps theres some other techniques available
 
I limited the number of records in the list box and that solved the problem. The list box really is the best way for what I am doing. It is acting like a search field. It takes the sample ID numbers from the main table and lists them as you type. When you click on the number or hit enter it takes you to that number. Listing them all is an easy way to facilitate fast switching between numbers 5 or 6 numbers apart.
 

Users who are viewing this thread

Back
Top Bottom