Saving Sub Form Data Separately

[TheFitz]

Hi All,

I've got a form, with a subform included (parent/child).

I've been asked to make changes to the system. Due to the way the enhancements are needed, I have had to create my own code to save, move records etc, intead of using the std Access record selectors.

No problem with this, all the above works correctly, however, the subform data is still direct data access. Therefore it's possible to undo the changes on the main form, but the sub forms changes are forever!!!

Anyone got any suggestions on how to get around this problem?

Many thanks for any input you have on the above,

Fitz
Did you know, there are 10 types of people in this world:
* Those who understand binary
and
* Those who Don't!!

 

[dhookom]

You could push the subform records to a temporary table for editing in the subform. When you want to "save" them, you would need either update or append functionality.

Duane
Hook'D on Access
MS Access MVP