Disable Command Button

[gear]

I have a command button which will work on a specified date of every year. After the user clicks it once (which will carry out calculations), I want this button to be disabled so that it is not available for second click. Is it possible?

 

[neoklis]

Yes it is possible… The command line is:

Me.buttonname.Enabled = false

You can type it on an open event properties on a form. So when your form opens you can check if the date is your run date.

If date=rundate then
Me.buttonname.Enabled = true ‘runable
else
Me.buttonname.Enabled = false
endif