I have a command button with code in the When event. Sometimes when the button is clicked the code in the button is not executed, other times it works fine.

How can I make it fire every time?

thanks