Hi all ,
i am struggling with the problem of how to read data from a database and insert it into an online form.
Basically the setup is as follows :
 - user inputs information into online form either by typing or selecting from various options shown and when finished hits submit button
 - data is successfully inserted into database

I can read from the database onto a 'blank canvas' ok but do not know how to insert the information that the user has inputted into the database into the form that was originally filled out.

Also , i would like to allow the user to be able to partially complete the form , logout , return to the form and be able to see what they have previously inputted and to continue from where they left of. If possible , i would also like to allow the user to change what they have previously inputted.

I am using MS Access 2000 as the database.

Thanhk-you for taking the time to read this plea for help and any assistance offered would be greatly appreciated,
larry101

this is really simple:

if you can read data from the DB, simply write the field contents to the HTML form fields. for example:

<input type="text" name="txtFirstName" value="<%=rs.Fields("First_Name").Value%>">

do this for all of your corresponding HTML form fields.

when the user goes to update their record, make sure you pass the record key w/ its value to your SQL statement. This can be written to a "hidden" input HTML tag in your form. While you'll probably query the database with a QueryString value (e.g. getrecord.asp?id=2) to retrieve the record initially, I typically pass the key from the DB as opposed to the key value from the query string:

<input type="hidden" name="intID" value="<%=rs.Fields("id").Value%>">

if the user is editing an existing record, simply pass the updated form data to an UPDATE sql statement and you should be good.

hope this helps.