The logic
1. You populate the dro-down box on the form with a recordset from your table
2. The .asp page processing the page will insert the value from the drop-down
Your insert statement will look like
insert into my table the values of request.form("field_name"
The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he who, in the name of charity and good will, shepherds the weak through the valley of the darkness. For he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee....
There are way around it. but it intails a bit of coding. In theory, you can have a different form that separate form perhaps in a layer that would populate the table and as soon as submitted the drop-down would contain the new entry. But I'm 99.99999% sure you can't type into a drop-down box. I believe there's a FAQ in this forum about this.
The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he who, in the name of charity and good will, shepherds the weak through the valley of the darkness. For he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee....
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.