Database - Recordset - Using sql query results in a HTML Form Select statement?

So I am building a form in which I wish to have a drop down box that is populated by a SQL select query. I think I know how to do this. You basically put the select statement inside the Form's "select" options using a loop.

I think I can get that done. But I ALSO need the user to be able to enter his/her own text as an option as well. So if the option she is looking for does not appear in the drop down list, she can simply type it into the space.

How do I do this. I did some google searches, but all the examples I found were way to basic for what I need.


Thanks.

post the code you have thus far...

if it is not in the list you simply add it to list box values in the database upon submission...once we see what you have...we can guide you further