[AccessD] Leave Subform

John,

I'm ok with the events in the subform firing...

Plain English...I just want to change a field in the subform to a certain 
value when the user exits the subform.  I don't want this to happen when 
they just move to another record in the same subform.

Thanks,

Mark


>From: "jwcolby" <jwcolby at colbyconsulting.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Leave Subform
>Date: Thu, 20 Sep 2007 15:42:30 -0400
>
>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
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Gear up for Halo® 3 with free downloads and an exclusive offer. 
http://gethalo3gear.com?ocid=SeptemberWLHalo3_MSNHMTxt_1