How to Display Last Record Entered when Opening .accdb File?

[tatihulot]

With Access 2013, how do you configure it so that when it opens a database, it displays the last record entered in a form? It is displaying the first record in the form when I open it.



I want Access to do this when I double-click the .accdb file. Thank you!

[amrut]

See http://msdn.microsoft.com/en-us/libr...ice.12%29.aspx
Use acLast option and put the code in the form's Open event

[tatihulot]

I'm a newbie and have never worked with code. Is there a simple tutorial that will guide me through this?

[orange]

If you record a DateEntered or something similar when you create a record, you can have your form based on a query that uses the Max(DateEntered) to get your desired record.
For vba tutorials see http://www.functionx.com/vbaccess/index.htm

[tatihulot]

As a matter of fact, yes, I do have a Date Entered field.

Now I just have to figure out how to set up a query so that it will open to the very last record.

I'm wondering if I need a time stamp as well, since I'm entering records all day long, and would I have to do the query based on a time stamp? Or would that be overcomplicating this?

[orange]

You need some date/time info that you can use to determine "Last". It isn't overcomplicating if you can have multiple records entered on any given Date.

Goo luck