How to Enable Button in Main Form when Subform is Dirty

[EddieN1]

I have a Main Form (Single Form View) and a Subform (Continuous Form View) with a Command Button on the Main Form. In the Subform, I have set default values in the detail so that when a new line appears, the form is immediately Dirty. In this state, the command button in the Main Form is disabled. If the user hits ESC, then the Dirty symbol (pencil) on the left goes away and the command button is enabled. However, I want to enable the command button without the user hitting ESC. Any way to do this? Thanks, Eddie

[EddieN1]

Well, I think I found this myself. In the On Current event of the Subform, I added...

If Me.Dirty then
Me.Undo
End If

Anything I might be overlooking? Thanks, Eddie

[ItsMe]

I would probably lean towards saving the record.

If Me.Dirty then
me.dirty = false
End If

[EddieN1]

ItsMe, the part I didn't emphasize is that if the record is Dirty when the On Current event triggers, then it is a NewRecord and hasn't been filled out yet. I don't want to save it unless something else changes in it. Thanks for your comment.

[ItsMe]

I fail to see the logic of using .Dirty or .Undo in the On Current event. You mentioned it provides a desired result. Not sure how the form is doing this. You know the function of the form better than I. Of all the actions to take in an on current event, an Undo seems to be the least desirable. If, in fact, you can take such an action I would try to avoid it.

[RuralGuy]

To add to ItsMe's observations, if in fact you are using the Default properties of either the controls on the form or the field property sheet, they will not Dirty a record. If in fact your record is getting Dirty then you are probably doing something else to the record. Just my $0.02.

[June7]

I agree, record is not initiated just because of DefaultValue property. Something else is happening.