hello ee,
My problem is i have an update form that shoots the records informatiion to the form and makes it editable. Everything works fine now. On my add form i have dropboxes available. How can i make those dropdown boxes available on my update form even though i have a recordset open to fill in the update form?
example
<!-- #include file="../header.asp" -->
<!-- #include file="../connect.asp" -->
Recordset.Open strSQL, Connection
strSQL = "Select Last_Name, First_Name, Location, Description, Other from Main Where ID = '" & varID & "';"
strSQL = strSQL & "Select Location from Location;"
<form>
<input type=text name="lname" size='20' maxlength='20' value='<%=Trim(Server.HTML
Encode(Rec
ordset("Pa
tient_LNam
e")))%>'/>
<input type=text name="fname" size='20' maxlength='20' value='<%=Trim(Server.HTML
Encode(Rec
ordset("Pa
tient_LNam
e")))%>'/>
set Recordset = Recordset.NextRecordset
<select name='location' ID="Select3">
Do While not Recordset.EOF
Response.Write("<option>" & Recordset("Location") & "</option>")
Recordset.MoveNext
Loop
</select>
<input type=text name="description" size='20' maxlength='20' value='<%=Trim(Server.HTML
Encode(Rec
ordset("De
scription"
)))%>'/>
<input type=text name="other" size='20' maxlength='20' value='<%=Trim(Server.HTML
Encode(Rec
ordset("Ot
her")))%>'
/>
<form>
<!-- #include file="../disconnect.asp" -->
<!-- #include file="../footer.asp" -->
Then spit out something like this
<D>
<A>
<B>
<C>
<D>
Start Free Trial