Main Form Jumps Back To 1st Record When Moving To Next Record In Subform?

[DaveCollins181]

When I add a record in the subform and then move to the next record whilst still in the subform, the main form jumps back to its first record? I then have to move back to the right record in the main form to update the next record in the subform. Is there anyway to fix this?

I want to move to the next record in the subform without affecting the main form.

Thanks Dave

 

[DaveCollins181]

Problem solved I had the following in After Update:

Private Sub Form_AfterUpdate()
Forms![FrmQuotations].Requery
End Sub

Wakey Wakey Dave Collins