Full Version: Message when changing value
UtterAccess Forums > Microsoft® Access > Access Forms
smittyssluggers
What is the best way to alert a user they are changing a value in a text box? I currently have a msgbox set up asking them if the want to proceed. But I need it to change back to the original value if the they choose "No". How can I do this?
ScottGem
In the On Change event of the control use:
If MsgBox("Are you sure you want to change this value?", vbYesNo) = vbNo Then
Me.Undo
End If
smittyssluggers
Works great! Thanks
ScottGem
Glad to assist
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.