Enable and disable buttons

[gheyman]

Can you use criteria to enable and disable buttons? (other than If statement that pops up a message box)

 

[Joe4]

I think we would need more details as to what you are trying to do, but one typically enables/disables buttons on a Form via VBA code, often in the Event Procedures (On_Load, AfterUpdate, etc).

 

[gheyman]

I want it to be disabled if two Text Boxes are null. The action the button takes requires data in these two fields

 

[Joe4]

What I would do is put VBA code in the Load event of the Form that checks the value in the two text boxes, and then sets it to enabled/disabled.
Then, add VBA to the AfterUpdate events on each of the two text boxes that checks the value in both text boxes, and if they are both populated, enables the button.

 

[stumac]

I would be inclined to put code in the on current event rather than on load that way each time you move records it will fire otherwise you could move from a record that meets the criteria to a record that doesn't and the button would be enabled.

 

[gheyman]

Thank you both. Any links to how to write that code?

 

[Joe4]

Here is an example: https://www.access-programmers.co.uk/forums/showthread.php?t=120104

If you Google "access vba event code enable button", there are many other examples.