[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 
Café. http://www.cafemessenger.com?ocid=TXT_TAGHM_SeptHMtagline1