complete cancelevent 
Author Message
 complete cancelevent

When I cancel the event
that would update the record
in the active form
the changed value remains
in the field, irritating the user.
The user has to press {ESC} explicit
to fully cancle her/his action.
How can I do that from within VB?
SendKeys doesn't work for me.

Steps that I've taken:
1. build a form to a table with a field shown
2. enter a record to the table
3. at the beforeUpdate-Event program docmd.cancelevent
4. try to change the field on the form, try to update
5. the record will not be updated (o,k.)
6. but the entered value remains

I want to see the old value
without hitting {ESC} manually.

Rolf



Tue, 25 Dec 2001 03:00:00 GMT  
 complete cancelevent
Rolf, look at the UnDo method in help

--
make a nice day,
TomG
Tampa, FL


Quote:
> When I cancel the event
> that would update the record
> in the active form
> the changed value remains
> in the field, irritating the user.
> The user has to press {ESC} explicit
> to fully cancle her/his action.
> How can I do that from within VB?
> SendKeys doesn't work for me.

> Steps that I've taken:
> 1. build a form to a table with a field shown
> 2. enter a record to the table
> 3. at the beforeUpdate-Event program docmd.cancelevent
> 4. try to change the field on the form, try to update
> 5. the record will not be updated (o,k.)
> 6. but the entered value remains

> I want to see the old value
> without hitting {ESC} manually.

> Rolf



Tue, 25 Dec 2001 03:00:00 GMT  
 complete cancelevent
Thank You, Tom

it works as desired



Quote:
>Rolf, look at the UnDo method in help

>--
>make a nice day,
>TomG
>Tampa, FL



>> When I cancel the event
>> that would update the record
>> in the active form
>> the changed value remains
>> in the field, irritating the user.
>> The user has to press {ESC} explicit
>> to fully cancle her/his action.
>> How can I do that from within VB?
>> SendKeys doesn't work for me.

>> Steps that I've taken:
>> 1. build a form to a table with a field shown
>> 2. enter a record to the table
>> 3. at the beforeUpdate-Event program docmd.cancelevent
>> 4. try to change the field on the form, try to update
>> 5. the record will not be updated (o,k.)
>> 6. but the entered value remains

>> I want to see the old value
>> without hitting {ESC} manually.

>> Rolf



Wed, 26 Dec 2001 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. CancelEvent

2. CancelEvent Method/Action

3. CancelEvent in Document_Close?

4. loop not completing correctly

5. pausing code until query completes

6. Print a complete treeview

7. Looking for information on extending TextBox control with Auto Complete features

8. vb webbrowser control,how to know it is complete loading

9. complete print screen from out vb

10. Access keeps completing my code!

11. track when shelled app completes

12. Percent Complete problem

 

 
Powered by phpBB® Forum Software