I need to issue a warning message if a set of conditions apply to the
current
record. I need to do this when I move off the record WHETHER OR NOT I have
made an update.
Currently, I have the code in the 'before update' event and the users are
complaining that it does not trigger when they access the record but make
no
changes.
The ideal place is the before update event. If a user is just hitting the
forward arrow a few times, are you saying that for each record they scan
over, you want this message?
The only way to accomplish this is would be have your own custom buttons for
navigation. A few here have suggested the on-current event, but that event
fires when you "land" on the record, not when you try move "off" the
record....
I would suggest that you consider making a "red" box, or something else on
the screen that highlights when you move "to" the record. Moving off of a
record does not mean much if I hitting the forward record button 5
times..and I getting a bunch of messages from records I don't even care to
read, or did not change.
Further, after the message is displayed, do you want to stay on the current
record, or after we display the message, do we move on to the next record?
(in other words, if you display this message, what is supposed to happen?).
So, you mean after we display the message, do we continue to move to the
next record? Or, how do we move to the next record then?
If this is an actual condition in the record that MUST be edited BEFORE the
user moves on, then use the before update to prevent this from happening. As
for the current mess, you need to find and fix those records. Build a query
that finds these bad records, and assign someone to fix them. Once you fix
the mess then users will not be able to exit a record when they edit it the
wrong way.
It don't make a lot of sense to pop up a message when a user is simply
moving along through some records unless they made changes to that
record....
