check to see if subform is dirty

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I like to add a dirty control to my close commands similar to this for
particular records:

....
with me
iIf .Dirty = True Then
x = MsgBox("Would you like to save before exiting?", vbYesNoCancel)
Else: DoCmd.Close acForm, stDocName
End If
End With
If x = vbYes Then
call modCmdButtons_cmdSaveClose
ElseIf x = vbNo Then
call modCmdButtons_cmdUndoClose
End If

Basically, the modCmdButtons will either close the form normally - saving
the record, or it will Undo the record and then Close - not saving.

PROBLEM:
I have a form with two unrelated subforms on it - no relations whatsoever to
anything - on purpose.
I want to be able to do something similar to the above if EITHER of the
subforms have had any changes made (The mainform is simply a holder for the
two forms).

Is this possible?
 
kremesch said:
I like to add a dirty control to my close commands similar to this for
particular records:
PROBLEM:
I have a form with two unrelated subforms on it - no relations whatsoever to
anything - on purpose.
I want to be able to do something similar to the above if EITHER of the
subforms have had any changes made (The mainform is simply a holder for the
two forms).

Is this possible?
Click to expand...

By the time your main form close command is running the two subforms will
already have had their changes saved so Dirty for both of them will always be
false.
 
Back
Top