Requery and stay on current record

• mbarr350

  SSC Enthusiast

  Points: 198

  More actions

  January 30, 2004 at 1:05 pm

  #66252

  How do you do a requery without returning to the first record? I need to stay on the current record.

  Is there a simple solution.  Thanks

• Kathi Kellenberger

  SSChampion

  Points: 11811

  More actions

  January 30, 2004 at 7:07 pm

  #492428

  You'll have to write some code.  Create a button on the form and change the lable to "Refresh".  Add code to the click event

  The code (not debugged) looks like this:

  Dim ID as int 'or whatever datatype your key is

  Dim rs as Object

  'save the current id

  ID = Me.IDField 'or whatever your key is called

  'refresh the form

  Me.requery

  'find the record

  Set rs = Me.Recordset.Clone

  rs.FindFirst "[IDFIeld] = " & ID

  'move to the record

  If Not rs.EOF Then Me.Bookmark = rs.Bookmark

  Hope this helps,

  Kathi

   

   

   

   

   

  Aunt Kathi Data Platform MVP
  Author of Expert T-SQL Window Functions
  Simple-Talk Editor