When startup check for last record

[rwahdan1978]

Hi,



When I start my switchboard (main page) I need to check a table for the last record (row) programatically, how to do that?

[Welshgasman]

How do you determine last row? autonumber, date/time ?
DMAX() would get you a field or several. If you need more than two or 3, I would use a recordset and perhaps a SELECT TOP 1 and order as needed.

[orange]

What exactly determines "last"? Please tell us more.

[rwahdan1978]

after making a new record it is saved last in the table, how to access last record in a table programatically?

[Welshgasman]

after making a new record it is saved last in the table, how to access last record in a table programatically?

If you have incremental autonumber, then that would be the last record added to the table.

[orange]

Records are stored in a table in no specific order-- very much like marbles in a bag. Order of retrieval/selection is based on a query "Order BY" clause. We need to know what LAST means to you to provide more focused response.

[davegri]

how to access last record in a table programatically?

Merely repeating your requirement over and over again is not helpful.
What data within the record itself defines that it is the last? A date? an Invoice Number? A primary key value?
You cannot reliably and consistently use the position of the record in the table to determine if it is the last.

[rwahdan1978]

Dim rs As Recordset

Set rs = CurrentDb.OpenRecordset("SELECT TOP 1 * FROM Turns ORDER BY ID DESC")
MsgBox ("Last Turn: " & rs!Person & " On " & rs!TheTime)
rs.Close
Set rs = Nothing

[davegri]

Make the recordsource for the form a query string.

"Select * from turns order by ID DESC"

[Welshgasman]

Best to always qualify your objects.

Dim rs As DAO.Recordset