Disable Close Button as Dirty_Form event

[Kirsty]

Hi again,

I'm new to VBA and would really appreciate your help.

I have disabled the "X" close button and created a Close button, which I want to disable as a Form_Dirty event. So that users can only Close the form if they haven't made changes or have Saved their changes.

However, as soon as I dirty the form, I get an error message pointing at this code:

 Private Sub Form_Dirty(Cancel As Integer)
cmdClose.Enabled = False
End Sub 

I really don't understand why I can't do this, probably simple, thing. Any help would be much apppreciated.

Thanks,

Kirsty

[ADezii]

Hi again,

I'm new to VBA and would really appreciate your help.

I have disabled the "X" close button and created a Close button, which I want to disable as a Form_Dirty event. So that users can only Close the form if they haven't made changes or have Saved their changes.

However, as soon as I dirty the form, I get an error message pointing at this code:

 Private Sub Form_Dirty(Cancel As Integer)
cmdClose.Enabled = False
End Sub 

I really don't understand why I can't do this, probably simple, thing. Any help would be much apppreciated.

Thanks,

Kirsty

I see no reason why you can't do this also. What exactly is the Error Message?