Select last recordset for view on endless form possible?

  • Thread starter Thread starter juvi
  • Start date Start date
J

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
 
juvi said:
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.
Click to expand...


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
 
Marshall said:
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
Click to expand...

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?
 
Back
Top