Nov 10, 2008 #1 bhulku MIS Jun 12, 2006 3 US How can I prevent navigating to next/new record if the values that I have conditions set is not correctly entered using VBA? Any help provided would be appreciated. Thanks
How can I prevent navigating to next/new record if the values that I have conditions set is not correctly entered using VBA? Any help provided would be appreciated. Thanks
Nov 11, 2008 #2 SeeThru IS-IT--Management May 2, 2002 585 GB Try the forms beforeupdate event: for Example If IsNull(MyImportantField) Then msgbox "please fill in the important information" Cancel = True end if SeeThru Synergy Connections Ltd - Telemarketing Services Upvote 0 Downvote
Try the forms beforeupdate event: for Example If IsNull(MyImportantField) Then msgbox "please fill in the important information" Cancel = True end if SeeThru Synergy Connections Ltd - Telemarketing Services
Nov 12, 2008 Thread starter #3 bhulku MIS Jun 12, 2006 3 US Thanks SeeThru for providing the exmaple. Works fine. Thanks bhulku Upvote 0 Downvote