When is a record saved?

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

I have a form which has a subform. The subform has a number of tabcontrols.
I understand that moving from the main form to the subform saves the data in
the main form and moving from the subform to the main form saves the data
in the subform. But what happens when you move between tabcontrols eg if you
move from page1 to page 2 has the data on page 1 been saved? The reason for
my question is I want to put a Cancel button on the subform to undo ALL the
data on the subform if the user has entered the data in error before they
move back to the main form.
Thanks
Tony
 
Tony said:
I have a form which has a subform. The subform has a number of
tabcontrols. I understand that moving from the main form to the
subform saves the data in the main form and moving from the subform
to the main form saves the data in the subform. But what happens when
you move between tabcontrols eg if you move from page1 to page 2 has
the data on page 1 been saved? The reason for my question is I want
to put a Cancel button on the subform to undo ALL the data on the
subform if the user has entered the data in error before they move
back to the main form.
Thanks
Tony
Click to expand...

Is the subform a single record form or a continuous view? If you move
between subform records then the record you just left is saved, but as long
as you stay on the same record just moving between TabPages should not cause
a save to occur unless some event code is running that does so.
 
Thanks Rick
Rick Brandt said:
Is the subform a single record form or a continuous view? If you move
between subform records then the record you just left is saved, but as long
as you stay on the same record just moving between TabPages should not cause
a save to occur unless some event code is running that does so.
Click to expand...
 
Back
Top