I have a form with a datasheet-view subform. On the main form is a cancel button so the user can stop making the order/invoice and cancel out.
When you press cancel, the beforeupdate event in the subform fires first, reporting errors about the data the user has just started to fill in, if any exist. Is there a way I can prevent this?
Also, I found that Me.Undo doesn't delete the subform or mainform records. I'm having to use sql delete statements. Is this necessary?