Shift form data without scroll bar

[ellenr]

Is it possible to set a subform so if data exceeds its space it will shift up one line? I understand I can use a scroll bar, but want the user to see the last entry without having to pick up the mouse to move the scroll bar to move it.

 

[CJ_London]

Why one line? Why not 10 or 20?

if only one line , why not just make the subform a bit taller?

 

[June7]

Code could move focus to last record or NewRecord when form/subform opens.

 

[ellenr]

Code could move focus to last record or NewRecord when form/subform opens.

But won't that put those lines at the top of the form leaving the rest of the form empty? And, actually, I want this to occur during use, rather than putting focus at last or new on open.

 

[CJ_London]

So you dont mean one line

You know the height of the subform detail section and the header if it has one. You know the height of the subform control. So you can determine how many records can be displayed. So having moved to the last record, you can move back that number of records.

 

[Pat Hartman]

If the latest records are most important, why not sort the subform descending by date?

 

[June7]

What do you mean by 'during use'? If user needs to view other records, they will mouse scroll or arrow buttons.