New Record to display

[L]

After adding a new record, I would like to display the newest record
after displaying all the records. Is this possible? I have already added
a field in the database (timestamp). Could I compare to where
the (timedatestamp = today or now).

 

[Stefan B Rusynko]

That won't work because the time changes between the 2 events (even if it is just a second)

Add a autonumber field to the DB as say recID (indexed - unique)
Then see the Access code at
http://www.aspfaq.com/show.asp?id=2174



| After adding a new record, I would like to display the newest record
| after displaying all the records. Is this possible? I have already added
| a field in the database (timestamp). Could I compare to where
| the (timedatestamp = today or now).