I have a form(frmInstalls) with a subform(frmMetrics) embedded. Within the main form (frmInstall) there are several combo and text boxes that I will enter information into. Within the Subform(frmMetrics) there are several text and combo boxes that I will enter information into. both form and subform are linked together by a key field. Problem -- After I enter information into the main form and click on a control in subform before update event occurs. I would like to enter data in main form then subform click Save button at which data is save to associated tables. How do I do that?


dc

Leigh, I have to admit, I didn't read your entire post above...but the last few lines made me laugh....

If you said this in your post, sorry..

But, couldn't you create a cancel that when clicked would undo changes made in your subform and also delete(using SQL) the main form record? Granted, the record would get saved still during your move the subform, but having a cancel button performing the step I mentioned above would accomplish basically the same thing....

J