Looking for some suggestions from the people in the know... Have a table with over 7000 entries... call these the suppliers....
On the page I want the user to select a supplier from a dropdown list...
My problem is the time it takes to populate the list. Can anyone suggest a better to allow the user to select a supplier.....

How about just leter links on the first page:

<u>A</u> <u>B</u> <u>C</u> <u>D</u>....etc.

&lt;a href="Results.asp?Alpha=A"&gt;A&lt;/a&gt; &lt;a href="Results.asp?Alpha=B"&gt;B&lt;/a&gt;

Then the results page which is a recordset displayed in a repeat region with all the suppliers begining with the letter selected, these in turn could be links to whatever you want.

varAlpha = Request.QueryString("Alpha"

RecordsetName.Source="SELECT SupplierName FROM SipplierTable WHERE SupplierName LIKE '" & varAlpha & "%'"

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

thanks for that... and thank-you for your time and effort.