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 - 10 Jul 2007 03:02 GMT
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.

Signature
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
> I'm trying to work up a set of actions in a macro that will send a message
> to
[quoted text clipped - 8 lines]
> just
> couldn't find one...). Thanks in advance!