ACCESS FEED: RE: [MS_AccessPros] How to show a warning msg, when user leaves a form

Rabu, 19 Oktober 2011

RE: [MS_AccessPros] How to show a warning msg, when user leaves a form

Dennis-

Is the form bound? (i.e. has a Record Source)

Please explain what you mean by "leave the form." Close it? Move to another
record? Put the focus on another form?

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Dennis Davidsson
Sent: Wednesday, October 19, 2011 3:47 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] How to show a warning msg, when user leaves a form

Hello,

I want to show a warning message to the user, if he leaves the active form
without having filled in all boxes properly, because none of the boxes must be
left with nulls.
I assume this can be accomplished by issuing a MsgBox statement in some Event
Property of the form.
But which is the relevant Event Property to choose for this, so that it covers
all possible ways of leaving the form?

Regards
Dennis Davidsson

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links