retrieve record from access into radio button in form (classic asp)

[puT3]

I have Customer table where there is a field called Company Type which store corporate or private. I want to retrieve the value in the table so it is diplayed on classic asp file in radio button. Im using Access.

im trying this in the asp file

<input type="radio" name="compType" value="<%=rs("compType")%>">Corporate<p>
<input type="radio" name="compType" value="<%=rs("compType")%>">Private
 

is this the correct way?Another is, is it the same for retrieve the value from table field into form list box and how access can retrieve value from the list box and saving it to the database?

[jhardman]

Off the top of my head, I believe the code should be:

<input type="radio" name="compType" value="Corporate"
<%if rs("compType") = "Corporate" then response.write "checked"%> >Corporate</input>
<input type="radio" name="compType" value="Private" 
<%if rs("compType") = "Private" then response.write "checked" %> >Private</input>
 

Jared

[puT3]

Thank you for this code