Display Confirmation Page before Inserting data to Access Database

[suchis]

Thank you for your assistance in advance.
What would be the code that I could use to display a confirmation page to a user before an Access database in updated with their information? Currently, I have a form with text boxes that the users will have to fill in with their information. The user then clicks on a Submit button and the data that the user entered is saved to an Access database and a confirmation page is displayed to the user. However, if the user wishes to edit the information they entered they will click on a button that takes them back to the form and then make the necessary changes after which time they click the submit button again. However, when I look at the database there are two entries for the user instead of one. Therefore, I would like to know if there is a way to have the confirmation page displayed before the data is inserted to the Access database?

 

[Noconi]

You would need to do this with ASP - FP doesn't have anything built in that will do this to my knowledge... so you would want to configure the form itself to post to an ASP "verify" page. The verify page would then use the request.form to:
a. display what the user has entered
b. send the form results, if verified by the user to the database.

with b. you would need to use the request.form to fill hidden fields and if the user clicks the "Verify" submit button then the form with the hidden fields would send to the original add record page. So you are basically jsut adding one ASP page and recoding the add record form to send to the verify page first - then from the verify page to the original add page that you already have in working order.

Here are some ASP resources that should help you get the coding for the verify pages together:

http://asp-dev.aspin.com/home?cob=asp-dev

http://www.4guysfromrolla.com

HTH
Tiffany

Microsoft MVP - FrontPage

http://www.at-frontpage.com

http://www.anyfrontpage.com

http://www.frontpage-webtemplates.com