[AccessD] Form Before Update

Never mind.  My response is incorrect.  Should have actually tried this
BEFORE chiming in.  Hope somebody else can shed a little light.

<returning to lurk mode>

Don

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mcgillivray,
Don [ITS]
Sent: Wednesday, August 31, 2005 2:40 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Form Before Update


Francisco,

Is it possible that you're using the *control's* Before_Update, instead
of the *Form's*?  At the control level, Before_Update will fire "before"
the update - that is, before the control's value is updated to whatever
you have typed.  Thus, the control will still contain its original
value.  With the form's Before_Update, you will be able to retrieve the
values that you have entered into any controls on the form, but it
doesn't fire until you save or otherwise attempt to move off the record.
If you're trying to evaluate what's been entered in a control either as
it's being entered or after, try the On_Change event for the control.

HTH

Don


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com