Disable Button after 3 clicks

[MrBill]

Hello- Promise, I searched before posting, but can't find a solution.

Simple question which hopefully has a simple solution:

- Is there a way to disable a button after a user has clicked it X number of times (3?)?

Thanks in advance for the help.
- Mr. Bill

[xLJer]

If the command button is on a form, you
can track the number of button clicks in
the button's Tag property, then disable
when the count reaches 3.

Please Login or Register  to view this content.

[thameem127]

try this code

Please Login or Register  to view this content.

[MrBill]

Hello- Thanks for the help. Couldn't get either of these to work.. Sure its something I'm doing wrong... here's what happened:

Please Login or Register  to view this content.

- This one just let me keep clicking. The button never disabled.

Please Login or Register  to view this content.

- This one threw me an error of: run-time error '424' Object Required


Any thoughts? Thanks again!

[thameem127]

Try instead with two buttons

Please Login or Register  to view this content.

[MrBill]

Hello- Thanks... you gave me an idea...

I just created 3 buttons. Each time one of them clicks, it executes the commands and then disables itself. After the 3 buttons, all the buttons are disabled.

Sort of wonky, but it works for now.

Thanks!

[thameem127]

Your welcome

Press star if u like my coding and mark this thread as solved.

[xLJer]

Because you posted back my identical code, I assume you tried
it and it failed because it did not register with your command button.
Whatever you named your command button, that is the name you should use
in your code. I chose "cmd1" for my button name.

If your button is named "Command1". Go to that button's click event
and add this.

Please Login or Register  to view this content.

and in your form's activate event, add this.

Please Login or Register  to view this content.

Why be wonky if you don't have to.