Requering Master Forms

[aqif]

Hi

I have one master Forms called FrmDrugApprovals and one subform called ApprovalPrescriptions. Whenever I enter subform entry and try to refresh the main form the main form goes to first record. Is there anyway I can keep the main form stay on the record it is ?

Cheers!
Aqif

 

[Rich]

Private Sub Address_AfterUpdate()
Dim rs As String

rs = Forms!Customers!CustomerID

DoCmd.RunCommand acCmdSaveRecord
Forms!Customers.Requery
Forms!Customers!CustomerID.SetFocus
DoCmd.FindRecord rs
Me.SubformField.SetFocus
Else
End If

End Sub