[AccessD] Old problem - forgotten the answer

Stephen:

Save the primary key in a long variable. Do the requery. Then use FindFirst
and bookmark to set the recordset pointer back to the  original record:

        Me.RecordsetClone.FindFirst "ClientGroupID=" & lngClientGroupID
        If Me.RecordsetClone.NoMatch = False Then
            Me.Bookmark = Me.RecordsetClone.Bookmark
        Else
            MsgBox "Could not return to selected record", vbExclamation
        End If

HTH 

Rocky



 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stephen
Sent: Saturday, November 17, 2007 11:04 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Old problem - forgotten the answer


On a continuous form containing record vestiges I click a button to bring up
a dialog box to edit the full record.  When that's finished, I re-query the
invoking continuous form to update the details.  This of course takes me
back to the beginning of the continuous form.  I want it to stay where it
is.  

I thought I had the solution once but can't find it.  Any ideas .....

Stephen Bond

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.503 / Virus Database: 269.16.0/1136 - Release Date: 11/17/2007
2:55 PM