[AccessD] Old problem - forgotten the answer

But how can I know when the invoking form gets the focus back from the
now closed dialog box.  I tested some (not all) events in the invoking
form (GotFocus etc), and none seemed to fire.  There is something I'm
missing here ...

BTW the invoking form is a subform of a tab in a tab control, but that
shouldn't matter should it?

Stephen

-----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