Form showing the last record 1

[canett]

After updating my continous form it shows not the last
but the prevuous record.I need a code that requeries
the form and shows the last order available something
like that
me!requery
me.order = last( This is my target,not the code of course)

How can i do it ?

 

[HandsOnAccess]

Place this statement at relevant event.

DoCmd.RunCommand acCmdRecordsGoToLast

Regards,

 

[ProgramError]

Or...

DoCmd.GoToRecord , "", aclast

aclast can also be acnew or acfirst

Ian Mayor (UK)
Program Error
Programmers do it one finger at a time!