Dropdown List Pulled From Large Table

[JaimeCCS]

Hi,

 

I have an airport table with more than 16,000 records and I need to pull the airport code to a dropdown list control. This are a lot of records for  a dropdown.

 

In my form I have to fields, Origin and Destination. Those fields are for the ICAO airport codes, but for some reason the the dropdown just pulled down 10,000 records, is this a limitation?

 

There is another way to point this.

 

Thankyou

Jaime

Monterrey, Mexico

[LWSChad]

Use an AutoComplete and use the table that hold the airports as the lookup.

 

When users type "Chi" a list will show:

Chihauhua International

Chihauhua Field

Chimalhuacan Municipal

Chicoloapan de Juarez Field

etc.

 

As the user types more the list will become smaller

[JaimeCCS]

Thankyou Chad, that worked.

 

Jaime