I have a simple form with one text field and one button. When I submit text from the form, I want it to display the corresponding field name from a recordset.

Example: If I type Last_Name in the form and submit, I want the recordset field named Last_Name to display.

So, I figured:
<%=(Recordset1.Fields.Item("Request.Form("wildcard _column")").Value)%>

would work, but no. Is this the right way to do this

<%
FieldName = Request.Form("wildcard_column")
'add logic to check if field name exists or not
response.write Recordset1(FieldName) 'Will give you the value
%>
Hope this helps

Om Prakash