'In this example, on double click, you save the current record ID, It then refreshes & requerries the form, and then goes back to the form record you were on when you double clicked the button
Private Sub Command91_DblClick(Cancel As Integer)
'Declare the variable
Dim StrValue As String
Set the StrValue
StrValue = ItemID
Refresh
Requery
'Sets the focus to the field you want to go to
Me!ItemID.SetFocus
'Go to the record where the field is= to the value of StrValue
DoCmd.FindRecord StrValue, , True, , True
End Sub