Moving to last record in a bound form in Access
Posted on 2003-03-19
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.