Select last recordset for view on endless form possible?

[juvi]

Hello,

How can I set the current record viewed on an endless form - I want to
"scroll" down to the last recordset on the endless form to show the newest
after added data.

Thanks for any help in advance.

juvi

 

[Marshall Barton]

How can I set the current record viewed on an endless form - I want to
"scroll" down to the last recordset on the endless form to show the newest
after added data.

If the form's record source query sorts the records by a
date field that can be used to determine when the record was
created, then you can use code like:

Me.Recordset.MoveLast

 

[Mike Painter]

If the form's record source query sorts the records by a
date field that can be used to determine when the record was
created, then you can use code like:

Me.Recordset.MoveLast

You should get the same result if there is no key or if it is sequential in
any manner.
Does Access use a key index if you just open a table in a "raw" form?