Set Focus on last record

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

In a subform which is in 'continuous forms' mode, I want to programmatically set the selection to the last record displayed in the subform. I have tried:

DoCmd.GoToRecord , , acLast

and I get the following error

"You can't use the GoToRecord action or method on an object in Design view."

This is not in Design view so the error doesn't help point to the problem. Any help is appreciated.
 
If you are trying to do it from the main form, try

Me.Subform.Form.Recordset.MoveLast

if you are in the subform, simply

Me.Form.Recordset.MoveLast

Hope this helps,
Pavel
 
Back
Top