If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
event when leaving a record without update
In data entry view of my form, I would like to post a msgbox if the user
leaves a record and a specific field has no value. What is the event that triggers this. Before/After Update does not work since I also need this even if no update is made in a record (the user has only looked at a record). I tried event unload too, does not work. Thanks in advance! -- smoeller |
#2
|
|||
|
|||
event when leaving a record without update
I can't imagine why you would want to pester people with a message rather
than requiring a value in the first place, but I suppose you could make your own navigation buttons instead of the built-in ones, and test the field's value as the first thing in the command button code. SMoeller wrote: In data entry view of my form, I would like to post a msgbox if the user leaves a record and a specific field has no value. What is the event that triggers this. Before/After Update does not work since I also need this even if no update is made in a record (the user has only looked at a record). I tried event unload too, does not work. Thanks in advance! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200910/1 |
Thread Tools | |
Display Modes | |
|
|