Me.Dirty....HELP? 1

[THEGREEK]

Hi,

Is there anyway, if a have a mainform, and on that mainform I have two other subforms - to do a check for like mabye Me.Dirty or (subfrmNAME).dirty etc etc...to find out if the form's recordsets have changed?

IE. sample coding;

If Me.Dirty = False Then
DoCmd.Close
Exit Sub
End If

Me.Dirty works for me on any stand alone form, but I was wondering if there is any other method I can use in conjuction with subforms on a mainform?

Hope I didn't confuse u

Thanks for your help in adavnce

THEGREEK

 

[JerryDennison]

While you can test for the .Dirty property of a subform from another form. Once the subform has lost focus any pending record is automatically saved. So it's really a moot point. You should test for .Dirty on the form that needs to be tested.