Last Record in Data Sheet

[olerebel]

In my database I have all my clients information in the [Main] form and all their transactions / debits / etc. in a subform [Transactions] in datasheet view. My question is how can I have the subform automatically scroll down to the last record (or to a new record) so the user doesn't have to scroll down everytime a new client is viewed?

-Alex

 

[RuralGuy]

If the SubForm query has an AutoNumber then sort on it Descending and no scrolling required.

Edit: The other option is to set the focus to a control on the SubForm (a two step process) and then go to the last record. e.g.

[COLOR="Green"]Me.SubFormControlName.SetFocus                      '-- Set Focus to the SubFormControl 1st
Me.SubFormControlName.Form!txtControlName.SetFocus '-- Set Focus to the Control on Subform
DoCmd.RunCommand acCmdRecordsGoToLast           '-- And move to the new record[/COLOR]

 

[olerebel]

Perfect

Thank you, that is exactly what I was looking for! Now, how would I execute an event procedure from a 'find' button? I have it working with the 'On Load', Next and Previous buttons.

 

[RuralGuy]

Have you tried putting the code I supplied in the Current Event of your form?

 

[olerebel]

Yes

It works great Now on similar lines (not directly related) when I switch my focus else where, how can I store the previous focus so I can return back to it?

 

[RuralGuy]

Before moving the focus save the Screen.ActiveControl or maybe the Screen.PreviousControl and then set the focus bak to it when you are done.