<div>
Jshesek's solution is incomplete since you need to select the fields that are in the same record as the max(id). &nbsp;You can do it with a sub select that finds the max and the outer query selects all the related fields or you can select the set of records you want and sort them descending by ID. &nbsp;Use the Top 1 predicate to select only the row with the highest autonumber value.
</div>


Jshesek's solution is incomplete since you need to select the fields that are in the same record as the max(id).  You can do it with a sub select that finds the max and the outer query selects all the related fields or you can select the set of records you want and sort them descending by ID.  Use the Top 1 predicate to select only the row with the highest autonumber value.

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I am creating a web application based on vb.net <br />
I would like to show the last added record to an access database table, on one of my forms.<br />
How can I do it? I have tried using formview tool, but did not work out how to make it show the last added record.<br />
<br />
Thanks a lot!
</div>
</div>


Hello,

I am creating a web application based on vb.net 
I would like to show the last added record to an access database table, on one of my forms.
How can I do it? I have tried using formview tool, but did not work out how to make it show the last added record.

Thanks a lot!

Showing last record of a database table on web form

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

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

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,