subform problem

[Kurt Neumann]

I have a subform with a field linked to the master form in a one to many.
the subform fields (all in a continuous view, perhaps 3 to 5 lines) can be
filled in by the operator and saved in it's corresponding table. I want to
be able to abort the addition if the user so chooses, but when I add code to
the subform to not save or to make the field null, only one of the records
blanks the field, the others stay and are added when the form is closed. i
even wrote an update query to set the values to null but it didn't work. Is
there a simple way for a relative beginner?
thanks in advance.
khn

 

[TC]

There is no really simple way to do what you want AFAIK. Access
unconditionally saves each record, when you move to the next one.

One approach would be to base the foms on temporary tables which you
populate with the relevamnt data. Then, when the user clicks a "Save It
All!" button, the form would copy all additions, edits & deletions from
the temporary table, back into the actual main tables. But that would
not be easy for a relatve beginner to get working.

Maybe someone else will have some other ideas.

HTH,
TC (MVP Access)
http://tc2.atspace.com