lastRecord

[24sharon]

Hello all,

I want to open subform at lastrecord.

On the subform (open) I write

Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acLast
End Sub

Bat it's not good for me because when you go to other record it's doesn't work.
If I put this code in the event of "Current" its work good but I cant change the other record and to add

Is there an idea to do it?
thanks s.

 

[24sharon]

thanks

but its not good for me because when you have to install a record you have to go down... and its not good.

there is no idea to see the last record??

thanks
s.

 

[24sharon]

Thanks I Got It

http://www.utteraccess.com/forums/showflat.php?Cat=&Board=access_2000&Number=432883&fpart=