[AccessD] Old problem - forgotten the answer

More info.  The Requery is done from the dialog box form.  It requeries
the invoking form.  

S 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Sunday, 18 November 2007 8:30 p.m.
To: Stephen
Subject: Re: [AccessD] Old problem - forgotten the answer

Stephen,

In a nutshell... You need to assign the primary key value of the current
record to a variable, prior to the requery, and then after the requery,
you can use code to find that record again.

Regards
Steve


Stephen wrote:
> 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