I am running this code to requery and not reset the tab order but the data resets to the first record in the database. This code is on a subform field. The main Form has a unique id linking to subform and then each subform reocrd has a unique value. I need this to stay on the current main record and subform record
Private Sub Error_Amt_AfterUpdate()
Dim lngID As Long
lngID = Audit_ID.Value
'force calculations ...
'navigate subform to the record you were working on ...
Me.Recordset.FindFirst "[Audit_ID]=" & lngID
'now reset the focus ....
Me.Parent.FinancialAccuracy = Me.Text100