I want to get the previous record based upon ID which is PK of the table.
Users are allowed to delete records from the table.
Problem:
Coz ID is autonumber,every time new record is created,it generates a new ID number for the record.When user delets that particular record, that ID number doesnt get deleted. When user enters new data, ID generats next available number and doesnt reuses the ones from where record has been deleted.
Now my problem is,i need to show previous record on the form.I can show last one based upon Max(Id). AFter that how would i calculate ID to pick up the second last record and so on....
I am really stuck, any help is appreciated.
Thanks