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?
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.
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#
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here