Clearing a form and a record stack.

[bluedigital]

I have a screen form which students enter data when they walk into our office for assistance.
There is a SUBMIT button on the form which shows a message that the form has been submitted, and then closes the form and takes them back to the Access Switchboard.
I chose this method vs. keeping the form on the screen because the records that students enter for each day stack up, (i.e. they can get to the previous student's records from the controls at the bottom of the Access screen.
Is there a way after pressing the SUBMIT button to clear the form, show the message, keep the form ON the screen, and clear the record stack, so they can not even see the one record they just entered?

 

[RuralGuy]

Set the DataEntry property to YES. It is on the Data tab of the property sheet for the form.

 

[joeyo34]

If you want it to open up a new entry you could use a macro attached to the "Submit" button that would basically save the information just entered into the form and then clear all information so that a new entry could be typed into it.

Also, if you would like to hide the record selectors you can goto the form's properties and under the "Format" tab you can choose whether or not the form has record selectors or navigation buttons. I typically set record selectors, navigation buttons, and dividing lines all to "No" which gives it a much smoother feel and keeps people from changing previous entries.

 

[RuralGuy]

Setting DataEntry to YES forces the form to only display *new* records. As soon as the record is saved the form moves to a new record, basically hiding all of the previously entered records. Removing the Navigation buttons from the form as suggested by joeyo34 is also a good idea.