Re: Adding MsgBox to a form
- From: John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 16 Sep 2009 13:47:49 -0600
On Wed, 16 Sep 2009 09:38:01 -0700, troublecat12
<troublecat12@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I am a novice Access user. I would like to build a msgbox On Enter for a
check box field and also for a text box in my form.
The message would read,"Are you sure you want to update this field?"
What is the simplest way to do so?
Thanks,
Mary
Just one caution - Dave's BeforeUpdate code is the way to do this, but I have
to be concerned: do you WANT to do this? If users routinely get nagged by
messages like this, they'll pretty quickly tune out and just unthinkingly
click OK: "Yes, dammit, I updated it because I wanted to update it!"
Add the code if you want, but do be aware of the downside!
You may also want to modify the code to avoid the message if this is the new
record:
If Not Me.NewRecord Then
MsgBox...
End If
--
John W. Vinson [MVP]
.
- References:
- Adding MsgBox to a form
- From: troublecat12
- Adding MsgBox to a form
- Prev by Date: Re: rounding problems
- Next by Date: RE: I want to display a word but do a calculation the result
- Previous by thread: RE: Adding MsgBox to a form
- Next by thread: This Recordset is not updatable?
- Index(es):
Relevant Pages
|
