Rod-
If you truly "dirty" some fields in the current record in code, the BeforeUpdate event of the form should fire when the user moves off the row. What does your code look like that "updates" the controls? Are the controls bound?
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Apr 21, 2014, at 2:46 AM, <desertscroller@cox.net> <desertscroller@cox.net> wrote:
I have a form where a couple of the controls are updated via VBA code. If the user makes no other changes on the form ( which is a subform) the before update does not fire. If the subform is exited and re-entered then it fires or if the parent form is advanced to a new record. My issue is the user may not remember the changes he made and then select not to update. I would like to present the update question when the user moves to another subform associated thru tabctrls. Can this be done very easily?
(Access 2010 on Windows 7 and 8.1)
Rod
(Access 2010 on Windows 7 and 8.1)
Rod
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar