Max Records In Combo Box

[chas]

Hi Gary,

by default, Access sets a limit of 1000 rows for lists.
You can overcome this by choosing Tools|Options and
selecting the Edit/Find tab and modifying this figure in
the 'Don't display lists......' box.

However, the number of records that you want to display
does appear excessive for a list/combobox. It may be more
efficient to progressivly filter the list with a series of
other list/comboboxes. See the following Microsoft
article for Access 2000:

http://support.microsoft.com/?id=209595

(ACC2000: How to Synchronize Two Combo Boxes on a Form)

hth

chas