I need to requery after updating a field without the tab order reset. I am using the code below but it keeps erroring out. Each Record in the subform has a unique Detail_ID and when the Error_Count_Audit_Type gets focus, the requery works fine but the tab resets to the first field in this record. After the code executes, I get a Runtime error "Engine does not recognize 'Error_count_Audit_Type2' as a valid field name...I am lost please help
Private Sub Error_Count_Audit_Type_GotFocus()
Dim lngID As Long
lngID = Detail_ID.Value
'force calculations ...
'navigate subform to the record you were working on ...
Me.Recordset.FindFirst "Error_Count_Audit_Type" & lngID
'now reset the focus ....