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.
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.
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.