Getting Text Box to work with Form

dunkingman

Registered User.
Local time
Today, 02:45
Joined
Jul 2, 2001
Messages
22
I have a text box on a form. In this text box the user types in the
abbreviated names of clients. In the BeforeUpdate Event, I put a prompt to
ask them if they are sure if they want to update this record, and while it
works if they click Yes, I need for the following to happen: If the user
clicks No (they don't want to update the info), I would like for the initial
value that was already in the text box before the user changed it to be
displayed. It seems easy but I can't figure it out, so can someone help me
please? I know I just asked another question yesterday, but I really need
help on this, and I will try to keep my questions at a minimum in the
future.

Also, thanks to the person who answered my question yesterday (charity). I
am having someone else post this because I don't have access to the internet
right know because of firewall issues. That's why I didn't post a reply
thanking you
 
sure, if they answer no, do the following...

Cancel = True
Me![FieldName].Undo

This will cancel the update and undo the changes made. Hope that helps.

Doug
 

Users who are viewing this thread

Back
Top Bottom