Not a very elegant workaround
Jim W said:
The difference is that the command button I'm want to disable is on the form not the header or footer. Each record or form has the button.
Jim
What you need is to set Conditional formatting, unfortunately Command buttons do not support that feature.. Maybe in the next version of Access
Well there is a work around to that, but before let me state that Ihave found that putting controls inside records is not a good practice when using Continuous forms, every single function can be done using buttons on the header/footer, or putting the continuous form inside an unbound form and seeting the controls on the unbound form. My advise would be to put the controls in the header and work from there...
That being said:
You need to set a Textbox and use it as a button, a textbox is one of the few controls that support Conditional formatting.
See Example.
I set up a text box and set conditional formating to Disable the textbox depending on the value of the checkmark, also once you click the textbox the focus is sent to another control on the form so, for the casual user the textbox will almost appear as a button...
As far as I know that is the only solution....