I'm using dreamweaver mx.I have a form called evaluation form.I also have an access database that i use to store data.I want the user to open the form and select a value in combo box called cborecnum.When the user selects the value in combo box i want it to display the data in the table on
the form.after the user makes the necessary changes i want to update the database.

I'm using dreamweaver mx with asp pages.I'm using ms-access database to populate data from table onto my form.the problem is my combo boxes does not display data with quotes.when the user selects the texts.it cuts the text after quotes.
i want it to display the whole text.

Post your code.

<td>*New Criticality Code:</td>
<td>
<%Set newcritcode_data=db.Execute("Select * from tblcriticality order by description"%>
<select name="cboNewcritCode">
<option value="same"> Select new crit code</option>
<%Do While Not newcritcode_data.EOF%>
<option value="<%=newcritcode_data("name"%>"><%=newcritcode_data("description"&" - " &newcritcode_data("Name"%></option>
<%newcritcode_data.MoveNext
Loop
Set newcritcode_data=nothing%>
</select>
okey heres is my code that gets data from data from table called criticality.
It displays description and name in combo box.my description field has text with quotes.
it cuts the the text.i don't know what to do.

Okey i got the combo box right.now it's with the text field.

Set select_data=db.Execute("SELECT * FROM tblMRP"
<td>Unit of Measure:</td>
<td colspan="6"><input type="text" name="txtUnitOfMeasure" value="<%= select_data("field12"%>" readonly="true"></td>
</tr>

ok first i'm getting data from the table mrp and then i display it on my form in the text field.
the field name in my ms-access table is field 12.
the text field only displays data before the combo box.it then discards everything after the quotes.
it does not display the whole text only the text before the double quotes.

I'm seriously stucksnd don't know what to do.I want to change the date fpormat.
I'm using dreamweaver mx with asp pages.I'm using the following code
to display current date.
<td align="right">Date:</td>
<td><input type="Date" name="txtDate" value="<%=Date() %>" readonly="true"></td>
it gives me the format in m/dd/yyyy i want to change the format mm/dd/yyyy
can you please help me
thanks