DoCmd.GotoRecord doesn't work for subform after changing mainform rec.

[inso18]

Hi Everyone.

I have a main form with a subform, they are bound with a common key (linked child and master fields).

After changing a record in the main form I try to execute

Call Me.sfrmSubForm.Form.GoToLastRecord

Which is:

Public Sub GoToLastRecord()
    DoCmd.GoToRecord , , acLast
End Sub

but the subform stays on the same record...

I tried to put "DoEvents" before the code, with no success.

After changing the record, when I execute this function by a command button manually, it does work...

Does anyone know how to solve this?
Much thanks,
inso18

 

[inso18]

I'm sorry for the trouble,

A simple me.sfrmSubform.SetFocus command solves this.


thanks, inso18