Combobox not showing all values from rowsource

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Access 2003 ADP linked to SQL Server 2000. I have similar comboboxes
in a couple of forms. The rowsource for each combox is a simple select
statement on a table. When I open either form not all the values are listed
in the combox. The tables contain about 15,000 records each, but the combox
seem to list up to the 10,000 record. How can I make sure the combox has all
the values listed in it, so that when I start entering an item that starts
with an "s" for example the autocomplete feature will find the first item
that starts with an "S". I recently started using ADP so this is the first
time I run across this problem with a combox.
Thank you.
 
Try changing the default value for Default Max Records in the Advanced tab
of the Options window.
 
Figures it would be something simple as that. I was under options looking
for something like that and If I remember correctly I did look under the
Advanced tab for something having to do with max records to show, but I
missed obviously.

Anyway, that works just great!!, thank you very much Mr. Lafontaine.
 
Back
Top