Solved Button to Enable Disable Controls by Macro

[Sarah.M]

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

 

[theDBguy]

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]

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]

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

 

[theDBguy]

I make mistake I mean Button not Toggle Button

I just did a quick test, and this one works for me.

 

[Sarah.M]

I just did a quick test, and this one works for me.

View attachment 98999

It works Thanks!

 

[theDBguy]

It works Thanks!

You're welcome. Good luck with your project.