1

Topic: Me. Recordset. MoveLast and all records on the screen.

All greetings!
In the principal form it is necessary to make Requery, and then in  Recordset. MoveLast.
Thus in the subordinate form the scroller of the screen of this subordinate form escapes in the bottom, and the last record becomes on the screen to the very top (for the first line).
I.e. it is visible only 1 record in shape - last.
--
Now a question.
How to make so that after MoveLast the last record was in the bottom of the screen.
Since is to users not conveniently...
While I find a way out so. I realize that it is a curve method... (In the screen form of 10 lines).

Form_Form2.Recordset. MoveLast
Form_Form2.Recordset. MovePrevious
Form_Form2.Recordset. MovePrevious
Form_Form2.Recordset. MovePrevious
Form_Form2.Recordset. MovePrevious
Form_Form2.Recordset. MovePrevious
Form_Form2.Recordset. MovePrevious
Form_Form2.Recordset. MovePrevious
Form_Form2.Recordset. MovePrevious
Form_Form2.Recordset. MovePrevious
Form_Form2.Recordset. MoveLast

2

Re: Me. Recordset. MoveLast and all records on the screen.

I.e. the analog - "down to an emphasis a castor of a mouse" in the tape form is necessary.
The castor never exhausts the last record to the very top...

3

Re: Me. Recordset. MoveLast and all records on the screen.

Instead of 9 calls MovePrevious it is possible 1 Move (-9).
That the screen did not twitch, it is better to do it in RecordsetClone, and then to appropriate Bookmark current record to the subform or it Recordset
Keep in mind that reversal Form_Form2 is not documented, and in shape without the unit is inadmissible. Use the standard reference from the principal form of a type:
Me! [Form2].Form. Recordset

4

Re: Me. Recordset. MoveLast and all records on the screen.

LightN;
If the subordinate form tabular will work how to you and it would be desirable, but at you, you mentioned the tape... It is possible to offer so

Me. Requery
Form_Form2.Recordset. Move (Form_Form2.Recordset. RecordCount - 9)
Form_Form2.Recordset. MoveLast

Where 9 is (10-1) if on the screen in the subordinate form 10 lines are visible

5

Re: Me. Recordset. MoveLast and all records on the screen.

OK!
Works, thanks!