Access 2005/sql server 2005: I retrieve data from the sql server and display/edit it in unbound forms. I've always had the problem that if I use the BeforeUpdate event handler to validate some input, the user has to press the escape key in order to undo his changes.
I've tried each of the following just before the Cancel=True statement:
and even this:
Public Sub KeySend(Keystrokes As String)
On Error Resume Next
Dim MyShell As Object
Set MyShell = CreateObject("Wscript.Shell")
Set MyShell = Nothing
I think it's because i'm using unbound forms. How can I simulate an escape key press in this situation?