acessing data back into form fields

Results 1 to 2 of 2

Thread: acessing data back into form fields

  1. #1
    Join Date
    Dec 1969
    Posts
    866

    Default acessing data back into form fields

    hi guys!!!,<BR>can anyone tell me how i can retreive my data that i have inputted using an html form into my access database back into my form fields(text area,text box...)that the i have used to input the data in the first place.I have tried using &#039response.write&#039 but to no use.Please help!!!i m stuck with this query for quite some time....<BR>thanx,<BR>sam

  2. #2
    Mark T. Guest

    Default RE: acessing data back into form fields

    Set rs = ...<BR>...<BR>rs.MoveFirst<BR><BR>&#037;&#062;<BR> ...<BR>&#060;FORM><BR>&#060;INPUT TYPE="TEXT" VALUE=&#060;%=rs.Fields("Field1")&#037;&#062;"><BR >&#060;TEXTAREA>&#060;%=rs.Fields("Field2")&#037;& #062;&#060;/TEXTAREA><BR>&#060;INPUT TYPE="RADIO" &#060;%If rs.Fields("Field3") = WHATEVER Then&#037;&#062;CHECKED&#060;%End If&#037;&#062;><BR>&#060;/FORM><BR>...<BR>&#060;%<BR>rs.Close<BR>Set rs = Nothing<BR><BR>-OR-<BR><BR>DIM str_HTML<BR>...<BR>Set rs = ...<BR>...<BR>rs.MoveFirst<BR><BR>str_HTML = "&#060;INPUT TYPE=""TEXT"" VALUE=""" & rs.Fields("Field1") & """>" & vbCrLf & _<BR>"&#060;TEXTAREA>" & rs.Fields("Field2") & "&#060;/TEXTAREA>" & vbCrLf<BR><BR>...<BR>rs.Close<BR>Set rs = Nothing

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •