[AccessD] find the right event

If Form 2 opened from  Form 1?  If so, open Form 2 as Modal and trigger the refresh  
immediately after the docmd.Openform "Form2"?

-- 
Stuart

On 30 Mar 2011 at 12:08, Jim Lawrence wrote:

> Hi All:
> 
> I have just been given the project to update an Access database 2003.
> 
> I am a little foggy on some of the methods and event so here is the
> question.
> 
> On form TWO a status field is toggled and then the form is closed.
> Form ONE, which was already open also has the same status field as in
> form TWO. Note: If you move off the current record, on form ONE, and
> back on again the status field updates correctly.
> 
> The issue is that I would like to have some way or be able to monitor
> some event within code to know that there has been a change to the
> form recordsource/record so the appropriate requery/refresh can be
> performed. 
> 
> So far I have found no form event that is triggered upon focus back to
> form ONE other than the Activate event but no programmed action can be
> performed at this point.
> 
> It does seem that this should be very simple.
> 
> TIA
> Jim
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>