Member Avatar for Majid Sarrouh

I am writing to an Access database by input into a form textfields and click submit
i am receiving a confirming new page that my record is submitted successfully. below the fonfirmation message, there is a hyperlink on the expression "return to the form" that when clicked, i am taken back to an empty form to fill in and submit another record.

I want to return back to the empty form without clicking the hyperlink
automatic go back after 3s - 5s for example.


Here is the code which is auto generated by Frontpage Database wizard to submit the record and display the confirmation message

FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0


	fp_rs.Update
	FP_DumpError strErrorUrl, "Cannot update the database"

	fp_rs.Close
	fp_conn.Close

	FP_FormConfirmationFromArrays "text/html; charset=windows-1252",_
						"Form Confirmation",_
						"Thank you for submitting the following information:",_
						"submission_form.asp",_
						"Return to the form.",_
						arFormDBFields0,_
						arFormValues0

End If
End If

Session.CodePage = Session("FP_OldCodePage")
Session.LCID = Session("FP_OldLCID")

%>
<!--#include File='login.asa'-->
<%
    If Session(SiteID) <> true Then
        Response.Redirect("Login.asp?requester=submission_form.asp")
    End If
%>


<% Response.Buffer = True %>
Edited by kvprajapati because: Added [code] tags.
  • 2 Contributors
  • 1 Reply
  • 199 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by ArtistScope

Dani AI

Generated

— FrontPage’s wizard prints a separate confirmation page (that “Return to the form.” link you see). is right that a client-side delay is the simplest fix, but there are three practical, reliable approaches depending on how you want the workflow to behave.

Client-side (quick and easy): add a meta refresh or a short JavaScript timer to the confirmation page so it navigates back after 3–5 seconds. Example meta tag:

<meta http-equiv="refresh" content="5;url=submission_form.asp">

Or JavaScript (preferred for more control and to avoid adding history entries):

<script>
setTimeout(function(){
  window.location.replace('submission_form.asp');
}, 5000);
</script>

Keep the “Return to the form” link for users without JS or who want to go immediately.

Server-side (PRG — Post/Redirect/Get): after saving the record, send the user back to the form with a status flag so the form page itself shows a transient confirmation message. Example:

Response.Redirect "submission_form.asp?submitted=1"

This avoids duplicate submissions on refresh and keeps the form as a normal GET.

Notes and troubleshooting: browsers sometimes repopulate fields when navigating back — to force an empty form set no-cache headers on the form page:

Response.CacheControl = "no-cache"
Response.AddHeader "Pragma", "no-cache"
Response.Expires = -1

Also consider accessibility: give users enough time to read the confirmation (3–5 seconds is reasonable). If the FrontPage function is hard to edit, replace the wizard confirmation call with custom HTML so you can insert the meta/JS or implement the PRG redirect.

Member Avatar for ArtistScope

For a timed delay it's best to use JavaScript.

But if you want to return to the submission form, why leave it in the first place, when you can submit to the same form and display the results that it reads from its own request fields... or retrieve the results from the last record added.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.