Subform not saving automatically

[RuralGuy]

Undoing the SubForm record changes cannot be easily accomplished once the record has been saved.

 

[RuralGuy]

I have one question, is there a way to undo the newly added subform record upon closing the form? The Customer Name can be saved in the Customers table, (because there was a prompt anyway), but can the same be done for the subform?

Assuming a PrimaryKey for the SubForm record, you could delete that record pretty easily.

 

[hprwdvd]

Hi RuralGuy,

Could you provide the code for deleting the just added Subform record?

Assuming a PrimaryKey for the SubForm record, you could delete that record pretty easily.

 

[RuralGuy]

You would need to save the PrimaryKey value of that record. Do you have it saved somewhere? If so, then a simple Delete query with a Where clause will do it. I don't know exactly what you have at this point or I could give you more specific instructions.