Display Last Record

[DNewman]

Hi, I am using Access 2010 in Windows 7.

With a continuous form, is it possible to load the form so that the last record has focus but is at the BOTTOM of the screen?

Pre-Windows 7 and with earlier Access I used Sendkey but I gather this is not a good idea anyway.

 

[John Big Booty]

You can use;

DoCmd.GotoRecord , , acLast

 

[DNewman]

Many thanks.
I have tried that but unfortunately this does not work (for me)
It sets the focus to the last record OK but displays it on its lonesome at the TOP of the page. I want it down the BOTTOM of the page ie showing the previous n records.

 

[John Big Booty]

I can't replicate that here in Access '03 will have a play with Access '10 latter in the day.

 

[John Big Booty]

Many thanks.
I have tried that but unfortunately this does not work (for me)
It sets the focus to the last record OK but displays it on its lonesome at the TOP of the page. I want it down the BOTTOM of the page ie showing the previous n records.

OK I've had a play in Access '10, and I see what you mean. I think the following should do what you are after;

Set rstSubForm = Forms!YourFormName.Form.Recordset

Do While Not rstSubForm.EOF

   rstSubForm.MoveNext

Loop

 

[DNewman]

Excellent, many thanks for your work on this one.
I will try it out when I get a chance