I have created a query via the data

[achau]

I have created a query via the database results wizard in FP to obtain data from Access. One of the search criteria is for the field "City"---- I already have a data table in Access for storing a list of cities. How can I change the free text box (create by FP DB results wizard, code below for this form field) into a drop-down list box (preferably generated from the Access data table)?

<input TYPE=&quot;TEXT&quot; NAME=&quot;City&quot; VALUE=&quot;<%=Request(&quot;City&quot%>&quot; size=&quot;20&quot;>

Thanks.

 

[tommcat]

Drop Down yeh?

<select size=&quot;10&quot; name=&quot;D1&quot;>
<option value=&quot;<%=Request(&quot;City&quot%>&quot; >
<%=Request(&quot;City&quot%></option>
</select>


This will be it...

Anything let me know...


Tommy