View Full Version : Getting Text Box to work with Form


dunkingman
07-13-2001, 07:11 AM
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

D-Fresh
07-13-2001, 07:35 AM
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