Keeping the focus on record being displayed

[Nic B]

I'm trying to work up a set of actions in a macro that will send a message to
users of a form about something they need to do before moving to another
record; the macro is displaying the necessary message box and is attached
tothe On Current property of the form. I can do everything I need to except
the fairly crucial bit of keeping the current record and not moving to
another record. I think I must be being dense, but would appreciate any help,
including pointing me to the right bit of an existing question here (I just
couldn't find one...). Thanks in advance!

 

[Allen Browne]

Run your checks in the Before Update event procedure of the *form*.

Cancel the event if you don't want the user to move on.