Auto Populate Drop-Down and funky issue

[norfeem]

I would like to auto populate a drop down menu named
Location. The infomation would come from an access file
with a field callled Location.

I tried adding <%Request("Location")%> to the form field
properties and no luck. How does this work with Front
Page?

Any Guidance would be most appreciated.

In addition I am using a search feature to populate a
results table. It is working with one exception. The
Search feature only works on the second attempt.

Here is what I am doing I open a page called xxx.asp in a
text field I enter Columbia The results say no entries
found. I enter Columbia in the same text field and submit
agian and a entry is found. Why on the second attempt and
not the first?

 

[+FarmerPickles]

Follow these instructions:
1 Click on INsert ---> database -->results
2. Pick your Db click next --> pick the table you want the info to come
from. click next
3. click edit list and choose the field you want to use. click ok.
4 click on more options if you want to sort the data
5 click next.. now in the dropdown, choose dropdown--one list per item.
click next
6 click finish
should be what you kneed

 

[norfeem]

how do you prevent duplicate entries from appearing.