No record selected with "DoCmd.GoToRecord , , acLast"

markzaal

Registered User.
Local time
Today, 15:30
Joined
Jan 15, 2013
Messages
50
Access 2010

Hi all,

I have a bound form (splitform view) with the code

"DoCmd.GoToRecord , , acLast"

on the Form_Open event. When I open the form it does go to the last record and shows all the data that are in (some of the) fields. I cannot however manipulate the record until I click on the navigation buttons in the bottom of the form. It also doesn't show which record ("34 of 34" for example) is selected.
Any idea how I can get it to open the last record and let me manipulate it directly on open?

Thanks!
 
Try to place it in the Form_Load instead.
 
That works! Thanks!

For some reason I cannot scroll horizontally through the datasheet in splitform view, even though I have Scroll Bars set to "Both".
Any thoughts?
 
You're welcome.
By me it is showed, see attached picture.
Is the form to small or wider as the fields in it non is showed.
 

Attachments

  • Ruler.jpg
    Ruler.jpg
    30.3 KB · Views: 246
The problem was in freezing the columns. I did this to maintain a custom order for the columns...
 

Users who are viewing this thread

Back
Top Bottom