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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
