Francisco Tapia
fhtapia at gmail.com
Thu Sep 1 13:55:22 CDT 2005
Thanks for the response... but the event is actually the Form's BeforeUpdate, I tried txtADE.text but that doesnt work either. This whole process occurs from a command button that I use to mark a hidden textbox w/ a 3, so when it receives the new value, I get the before_update (on the form) firing. On 9/1/05, Gustav Brock <Gustav at cactus.dk> wrote: > Hi Francisco > > As David indicates, use the Text property of the control to retrieve > the currently typed string before it is saved and while the control > still has focus; if it hasn't focus, Text is not available. > For a bound control, the Value property returns the stored value. > > /gustav > >>> fhtapia at gmail.com 31-08-2005 23:08 >>> > I have a bound form in an Access 2000 data project. I have a field > named txtADE, I set it to 3 and immediatly the before_update fires. > however in the before_update code if I try to reference txtADE it > shows my previous value, not the new one... what gives? > > thanks, > -- > -Francisco > http://pcthis.blogspot.com |PC news with out the jargon! > http://sqlthis.blogspot.com | Tsql and More... > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- -Francisco http://pcthis.blogspot.com |PC news with out the jargon! http://sqlthis.blogspot.com | Tsql and More...