UtterAccess Discussion Forums > How to Determine if a Control Has Been Updated.

Full Version: How to Determine if a Control Has Been Updated.

UtterAccess Discussion Forums > Microsoft® Access > Access Forms

dkemp

Jun 1 2006, 10:58 AM

I have a form with several date controls. The user can click an icon that opens a calendar and can then select a date that is put into the appropriate date control. Since Access doesn't recognize this as an 'update' to the control, is there a way to determine that this as an update so the an 'After Update' event procedure will run?

Thanks.

RuralGuy

Jun 1 2006, 11:18 AM

If it is a bound control then Me.ControlName.Value will not be equal to Me.ControlName.OldValue. You will need to put your code in the Icon code that invokes the calendar.

schroep

Jun 23 2006, 04:52 PM

You need to call the control's AFTERUPDATE event yourself after updating the value. For example:

Me.txtDate = #6/23/06#
Call Me.txtDate.AfterUpdate

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.