Solved Button to Enable Disable Controls by Macro (1 Viewer)

Sarah.M

Member
Local time
Tomorrow, 00:18
Joined
Oct 28, 2021
Messages
335
Hi, Plz note, My VBA is blocked by IT for security reason.
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
------------------------------------------------
I am trying to make Button Enable Disable, one click it works it disable the controls,
but if I click it again it did not Enabled the controls ☹️
plz help me to fix it 🙏

Sample attached

1646857999110.png
 

Attachments

  • 12.accdb
    1.9 MB · Views: 196
Last edited:

theDBguy

I’m here to help
Staff member
Local time
Today, 14:18
Joined
Oct 29, 2018
Messages
21,358
If you're using a toggle button, then you should be able to test for its state: true or false. I'm not sure why you're checking the OnClick property in your macro.
 

Sarah.M

Member
Local time
Tomorrow, 00:18
Joined
Oct 28, 2021
Messages
335
If you're using a toggle button, then you should be able to test for its state: true or false. I'm not sure why you're checking the OnClick property in your macro.
Thanks for replying
I want
on click enable controls and
on click disable controls
Tried .[OnClick] but it didn't work
Plz help!
 

Sarah.M

Member
Local time
Tomorrow, 00:18
Joined
Oct 28, 2021
Messages
335
If you're using a toggle button, then you should be able to test for its state: true or false. I'm not sure why you're checking the OnClick property in your macro.
I make mistake I mean Button not Toggle Button
 

Users who are viewing this thread

Top Bottom