Record positions in a display

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

While displaying record fields in continuous mode on a form,
a user takes an action that requires a Requery to properly
update the display. How do I maintain the positioning that
existed when the user was taken?

It may be here that Requery is not what I want at all. Rather
some other function that will cause the display to be updated
per the change just made to the record that has the focus.

Thanks,
Bill
 
Store a primary key of the record the user was on before
requery action

Dim keyID As Long
keyID = Me!MyKeyField
...
Me.Requery
...

' and now locate the same record:

With Me.RecordsetClone
.FindFirst "MyKeyField=" & keyID
If Not .NoMatch Then
Me.Bookmark = .Bookmark
End If
End With

HTH
 
All I needed to do was issue a Me.Refresh to see what was
changed in the DB as a result of the user action... a little sleep
didn't hurt.
Bill
 
Back
Top