[AccessD] Leave Subform

Mark, 

AFAIK this won't work.  The problem is that when you change a record on the
sub form events in the subform will fire.  

What are you really trying to do, in plain English?   


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Thursday, September 20, 2007 3:21 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Leave Subform

Hello All,

Have an A97 db...I have a subform/continuous...when I leave/exit that
subform I want to change a value on the current record of the subform.  I
thought I could do this by using the "On Exit" property of the subform.  The
problem is when I click out of the subform...the "on Exit" does fire...but
if I put code in that references the field I want to change...the click part
is cancelled and the subform maintains focus.

Any suggestions?

Thanks,

Mark

P.S...I can't use the "Before Update" of the subform itself...because going
to a new record in the form does something different.

_________________________________________________________________
Kick back and relax with hot games and cool activities at the Messenger
Cafi. http://www.cafemessenger.com?ocid=TXT_TAGHM_SeptHMtagline1