How do I get my command button to work after I disable it?

[Guest]

I have a command button that I disable when I open the form. When a change
is made to a field (On Change) the command button is enabled so that the user
can
click on it to apply changes. For some reason, once it is enabled, it no
longer
executes the macro behind it. The only way that it will work is to delete
the command button and re-create it! That doesn't solve the problem b/c I
only need the button to be enabled when a change is made on the form.

Any ideas on how I can get my Macro to still execute. The button acts as if
it doesn't have a command behind it.

Thanks!
Angie

 

[Dirk Goldgar]

I have a command button that I disable when I open the form. When a
change is made to a field (On Change) the command button is enabled
so that the user can
click on it to apply changes. For some reason, once it is enabled,
it no longer
executes the macro behind it. The only way that it will work is to
delete the command button and re-create it! That doesn't solve the
problem b/c I only need the button to be enabled when a change is
made on the form.

Any ideas on how I can get my Macro to still execute. The button
acts as if it doesn't have a command behind it.

Are we talking about true macros or VBA code? Or a mix of macros and
VBA? What are the code statement or macro actions that disable the
button? What are the code or macro statements that enable the button?