Based on your comments, I was able to fix the problem by moving everything in form2.fire() method into form2.cmdFire.click() method.

Since cmdFire.click() also runs PRG1, everything is working properly.

The clue came when you said when running prg1 from any button's click() method would allow the ON ERROR to trigger.

THANK YOU so much.