[AccessD] On_DblClick -> BeforeUpdate -> AfterUpdate

Joe
Create two functions to do your Before and After processing. The Before will return True or False. In BeforeUpdate set cancel according to the function's return value and in your Double-Click do something like:

If BeforeFunction()=True then
  Call AfterFunction()
End if

Just my suggestion.

Andy Lacey
http://www.minstersystems.co.uk

-- Original Message --
From: Joe Rojas <JRojas at tnco-inc.com>
To: "'accessd at databaseadvisors.com'" <accessd at databaseadvisors.com>
Send: 2003-02-04
Subject: [AccessD] On_DblClick -> BeforeUpdate -> AfterUpdate

Hi All,

	I have a textbox with a BeforeUpdate and an AfterUpdate event. If I
manually type the data in this text box the Before/AfterUpdate events fire
after I tab out of the textbox and everything work just dandy. How this
textbox really works though is that the user double-clicks on the textbox
and the system date and time are entered in to it automatically. Doing it
this way does not cause the Before/AfterUpdate events to fire. I was
thinking that I could just call the Before/AfterUpdate events from my
double-click event but I am taking advantage of the Cancel variable from
these two events. 

	My question is: How can I access the Cancel variable from my
On_DblClick event so that I can create my own control code based off of the
Cancel variable?

Thanks,

Joe Rojas
jrojas at tnco-inc.com