how to display last record added in a table in form

[Rizvi]

Hi
if any one can help me out. i have a table which is working as an audit trail having three fields id,staff and latest update date. this table will store the changes done in another table done by the staff and the latest date of changes done. i need to check and to display in a form the last record added in this table. if any one can provide me with vb code


thanks in advance
regards

[June7]

Records in table do not have intrinsic order. Need criteria to find the 'last' record. Could be a sequence identifier (autonumber field can usually serve) or a date.

SELECT * FROM table WHERE ID IN (SELECT Max(ID) AS MaxID FROM table);

or

SELECT * FROM table WHERE ID = DMax("ID", "Table");

[CJ_London]

autonumber may not be reliable for your purposes - perhaps you need a timestamp field - see this link for reasons why

http://www.utteraccess.com/wiki/Auto..._What_They_Are

in particular, look at point 4 for the illustration. This may not be relevant for your situation, in which case autonumber should be OK