wait until a save button click to save a subform into the table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi! I need help with this. I have a subform that read from a table and on
view. i will be changing some of the values of the records. it may be one or
many filed. rith now everytime i change a value in a box it will change it on
the table. What i want is, i want to have a save button. after the changes, i
want to press that save button and then it will write the values or records
on the table. I don't know how to do this, could u please help me with this.
first when i open up the subform it would upload and later on when i press
the save button it will store it. now it will do it on run time.
 
Thelee said:
Hi! I need help with this. I have a subform that read from a table
and on view. i will be changing some of the values of the records. it
may be one or many filed. rith now everytime i change a value in a
box it will change it on the table. What i want is, i want to have a
save button. after the changes, i want to press that save button and
then it will write the values or records on the table. I don't know
how to do this, could u please help me with this. first when i open
up the subform it would upload and later on when i press the save
button it will store it. now it will do it on run time.
Click to expand...

For a continuous form or a form/subform the only practical way to do this is
to bind the forms to temporary work tables and then use append and delete
queries to do the "save". There is no way in a bound form to move to
another record without the record you are leaving being saved. Likewise
moving from the main form to a subform or vice-versa will always save the
record in the form you are leaving.
 
Back
Top