Moving to last record in a bound form in Access

Posted on 2003-03-19
Medium Priority
Last Modified: 2008-03-17
I have a continuous form bound to a table in Access. When the form is loaded or opened, I would like it to be positioned at the last record not the first. I still want it to be sorted in ascending order. I tried using: 'DoCmd.GoToRecord "Job", acLast' where Job is the table name it's bound to, but when I try using the tables name as the object name an error msg tells me the table isn't open. I also don't know inside which event it would need to be placed.

Thanks in advance for any help on this.
Question by:Mendy
LVL 41

Accepted Solution

shanesuebsahakarn earned 200 total points
ID: 8171122
In the Form's OnOpen event, just use:
DoCmd.GotoRecord ,,acLast

Author Comment

ID: 8171370
Thanks Shane! It worked.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Implementing simple internal controls in the Microsoft Access application.
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question