Automatically goto last record in a subform

[Bauer99]

How you code for a subform to automatically go to the last record when the Parent Form record is changed. I added the code:

doCmd.GotoRecord , , acLast

on the Form_Load event of the subform, which works fine until the parent form is changed. I added the same code to the Form_Current event on the subform but then you cannot add a new record to the subform. Any tips?

 

[AccessAce]

Try using the GotFocus event.

 

[DJS2]

Try putting the following line in the forms "On Load" event:

DoCmd.GoToRecord , , acLast

This will take you to the last record