Requery Query? 1

[kpryan]

Hi all,
When on a form I uses the re query command .. the form always goes to the first record.Is there a way when the re query command is used that it stays at that same record?

Many thanks,

Ken

 

[Remou]

The only way is to save the unique key of the location and to use, say, the recordset clone and bookmark to return to that location after the requery.

 

[kpryan]

Thanks Remou,
for your reply, but how do you do that.? I'm not sure where to start with this.

Ken

 

[Remou]

Are you using a button or code to requery? If so, please post it.

 

[TheAceMan1]

Howdy kpryan . . .

. . . perhaps this:

[blue]   Dim hldID
   
   hldID = Me![purple][b][i]PrimaryKeyName[/i][/b][/purple]
   Me.Requery
   Me.Recordset.FindFirst "[[purple][b][i]PrimaryKeyName[/i][/b][/purple]] = " & hldID[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886