<div>
The record would not natively clear the records even when i used the new record command. &nbsp;It would just take me the bottom of the records.<br />
<br />
Scott
</div>


The record would not natively clear the records even when i used the new record command.  It would just take me the bottom of the records.

Scott

<div>
It won't &quot;clear&quot; the existing records, but it would instead take you to the new record section. You really can't do what you're after unless you create a separate &quot;Add Record&quot; form, and that's somewhat clunky.
</div>


It won't "clear" the existing records, but it would instead take you to the new record section. You really can't do what you're after unless you create a separate "Add Record" form, and that's somewhat clunky.

<div>
<div class="content wysiwyg-content">
I am using Access 2007. &nbsp;I have a form with about 25 fields and also 3 subforms. &nbsp;I would like to link the subforms so the data automatically saves, but I also would like the subfroms to be clear of data when entering the new record. &nbsp;Is there a way to do this?
</div>
</div>


I am using Access 2007.  I have a form with about 25 fields and also 3 subforms.  I would like to link the subforms so the data automatically saves, but I also would like the subfroms to be clear of data when entering the new record.  Is there a way to do this?

Adding new records to subforms

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.