Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / July 2007

Tip: Looking for answers? Try searching our database.

Keeping the focus on record being displayed

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Nic B - 09 Jul 2007 17:32 GMT
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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.