Me.Requery

  • Thread starter Thread starter JIM.H.
  • Start date Start date
J

JIM.H.

Hello,
I am using Me.Requery to refresh my tabular form after the
user click a button to delete a row. My problem is: the
first row becomes the current one. Is there any way I can
make the next row current after refresh.
Thanks
Jim.
 
Before you do Me.Requery, assign some unique value, e.g. RecordID, to a VBA
variable. After the Requery, use RecordsetClone of the Form to find the
Record with the value you store in the VBA Variable and set the Form's
Bookmark accordingly.

Check Access VB Help on Bookmark of the Form. I think there are sample
codes in the Help topic.
 
Back
Top