R
Richard
Hi
I am using an unbound form to enter and edit data.
1. When a user change a value in a cbo, a msg box will prompt OK-change,
Cancel-Undo. When the user clicks Cancel, the underlying code runs
"me.cbocompany.undo" It works well when I was using a bound form, now the
value remains the new value.
2. I use a text box to determine if the user changes any data with this code
in the onkeypress event:
Select Case KeyAscii
Case vbKeyTab
Case Else
Me.txtEdit = "Edit"
End Select
It works when I type something or press the space bar, it doesn't work when
i change value in a combo and when i use the delete key.
Appreciate if someone can help me with this. Thanks in advance
Richard
I am using an unbound form to enter and edit data.
1. When a user change a value in a cbo, a msg box will prompt OK-change,
Cancel-Undo. When the user clicks Cancel, the underlying code runs
"me.cbocompany.undo" It works well when I was using a bound form, now the
value remains the new value.
2. I use a text box to determine if the user changes any data with this code
in the onkeypress event:
Select Case KeyAscii
Case vbKeyTab
Case Else
Me.txtEdit = "Edit"
End Select
It works when I type something or press the space bar, it doesn't work when
i change value in a combo and when i use the delete key.
Appreciate if someone can help me with this. Thanks in advance
Richard