Clear Access Page on Save Record

[Trunk3d]

Hello all.
I have a Data Access Page that users can reach to submit a request. At the end of the page I am using a Command Button that is set to Save Record. Is there a way that upon pressing the command button and saving the record, all fields on the page can be reset to blank.....or perhaps move to the next record? Currently when opening the page, each field is populated w/ information from the previous submission.
Please forgive my ignorance, and thank you in advance for any help offered.

-Dao

[Rabbit]

Do you need to let the user be able to go back and edit old records? If not you can just set Data Entry to Yes. This will only let them enter new records.

If you do, then in the On Load event of the form you can have it jump to a new records. Which you can also use for the Save Button.

[Trunk3d]

Thank you much for the prompt reply. When I set the form's Data Entry to "Yes" it fails to save the input from the Access Page to the table that the form corresponds with. Being very new to Access, I am using a DB template from MSofts webpage and editing it. Here is the code from the Access Page I created. The code contains the button information down to the close of the html data access page. Everything works except I wish the fields would clear when clicking the Save Record button.
Thanks again
__________________________________________________ ___________
<BUTTON id=SubmitRequest style="Z-INDEX: 1; WIDTH: 1.813in; HEIGHT: 0.24in"
tabIndex=20 MsoTextAlign="General">Submit Request</BUTTON></FONT></STRONG></P>
<P><STRONG><FONT color=#ff0000>
<SCRIPT language=javascript event=onclick for=SubmitRequest>
try { if (MSODSC.DataPages.Count > 0)
if (MSODSC.CurrentSection == null)
MSODSC.DataPages(0).Save();
else
MSODSC.CurrentSection.DataPage.Save(); }
catch (e)
{ alert (e.description);}
</SCRIPT>
* Please Click The Submit Button Only Once *</FONT></STRONG></P>
<SCRIPT language=javascript event=onclick for=SubmitRequest>
try { if (MSODSC.DataPages.Count > 0)
if (MSODSC.CurrentSection == null)
MSODSC.DataPages(0).Save();
else
MSODSC.CurrentSection.DataPage.Save(); }
catch (e)
{ alert (e.description);}
</SCRIPT>
</BODY></HTML>
__________________________________________________ ___________

[Rabbit]

This is out of my area, we'll have to see if someone else can answer this question or move it to a different forum.

[Trunk3d]

I appreciate you trying. Hopefully I won't get flamed. :)