The only way around this is to create a report similar to your form
which contains all records. Then create a query which contains the
primary key from the table that the report/form comes off of. (I'm
assuming your primmary key is a auto-number) Once you are designing the
query you have to check the auto-number field and put the sort order in
desceding and then at the top in the Toolbar is a drop-down box titled
"Top Values" - change that to a "1" and run the query. It should bring
up the last record which was entered into the table.
Hope this helps
