Gale Perez
galeper at gmail.com
Thu May 3 18:59:12 CDT 2007
Hi! I have a form/subform and am trying to determine whether it is dirty, but "it" isn't seeing the record as having been modified whether I say "Me.Dirty" or the syntax below. I am not getting the message box to fire. I would greatly appreciate any assistance. Here is the basic code: If Me.mysubformname.Form.Dirty Then If MsgBox("Do you want to save your changes?", vbYesNo) = vbYes Then 'do whatever Else 'undo changes End if Else 'do whatever End if Once I get the message box to fire, I anticipate having problems changing the subform controls and wonder if Me.Undo, or the MS suggestion ctl.Value = ctl.OldValue, or if I would have to include a reference to the subform. Thank you very much for any advice. Gale