<div>
use a query based on the table that you are using as the record source of the form,<br />
in the query use an order by clause, something like this<br />
<br />
select * from TableName<br />
Order by ID Desc
</div>


use a query based on the table that you are using as the record source of the form,
in the query use an order by clause, something like this

select * from TableName
Order by ID Desc

<div>
I was more talking about the form design to begin with. &nbsp;What type of form should be selected. &nbsp;I see that the answer to that question is continuous.
</div>


I was more talking about the form design to begin with.  What type of form should be selected.  I see that the answer to that question is continuous.

<div>
<div class="content wysiwyg-content">
I have the entry form shown in the attached screenshot that does not have a very nice layout. &nbsp;Ideally, I would like the entry form to show all the records with the most recently added ones at the top. <a href="https://filedb.experts-exchange.com/incoming/2011/10_w44/517980/del.jpg" target="_blank" title="optimize form view (79 KB)"><img alt="optimize form view" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2011/10_w44/800_517980/del.jpg" /></a>
</div>
</div>


del.jpg

I have the entry form shown in the attached screenshot that does not have a very nice layout.  Ideally, I would like the entry form to show all the records with the most recently added ones at the top. 

Form and database optimization

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.

Microsoft Access

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.