Refresh Method 1

[Guest_imported]

How can you do to go back to the same record after using the Refresh Method in a Form working with Access??

Am I supposed to use the Bookmark Property?? How can I do it??

 

[Rohdem]

Try this:

Private Sub Form_Activate()
On Error GoTo ErrActivate:

Dim bmk As Variant
bmk = Me.Bookmark
Me.Requery
Me.Refresh
Me.Bookmark = bmk

ErrActivate:
If Err.Number = 3021 Or Err.Number = 3159 Then
Exit Sub
Else
MsgBox Err.Description
Exit Sub
End If

End Sub [sig]<p>Mike Rohde<br><a href=mailto:rohdem@marshallengines.com>rohdem@marshallengines.com</a><br>[/sig]