I IannWard Registered User. Local time Today, 06:08 Joined Feb 19, 2015 Messages 30 Mar 11, 2019 #1 how do I stop people clicking a toggle button to false if another field in a form is empty? Thanks
Ranman256 Well-known member Local time Today, 01:08 Joined Apr 9, 2015 Messages 4,349 Mar 11, 2019 #2 In the ON CURRENT event: Toggl.enabled =not IsNull(me.txtBoxFld) You might want this in the afterupdate too,if the user fills in the field so toggle can turn on.
In the ON CURRENT event: Toggl.enabled =not IsNull(me.txtBoxFld) You might want this in the afterupdate too,if the user fills in the field so toggle can turn on.
isladogs Access MVP / VIP Local time Today, 06:08 Joined Jan 14, 2017 Messages 19,326 Mar 11, 2019 #3 You could also use something like this on your toggle button click event Code: If Nz(Me.OtherControlName,"")="" Then Exit Sub Have you seen my solution to your other thread about the delete query which I posted on Saturday? https://www.access-programmers.co.uk/forums/showthread.php?t=304122
You could also use something like this on your toggle button click event Code: If Nz(Me.OtherControlName,"")="" Then Exit Sub Have you seen my solution to your other thread about the delete query which I posted on Saturday? https://www.access-programmers.co.uk/forums/showthread.php?t=304122