Link to home
Start Free TrialLog in
Avatar of Mendy
Mendy

asked on

Moving to last record in a bound form in Access

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.
ASKER CERTIFIED SOLUTION
Avatar of shanesuebsahakarn
shanesuebsahakarn
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mendy
Mendy

ASKER

Thanks Shane! It worked.