make a subform to wait until a save button is clicked

  • 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.
 
That's pretty much how Access is made to work, Thelee.
Can you help us understand why you want to wait to save your values until a
button is clicked?

It's possible to copy your values to a temporary table, make your changes
there, then use an update query to copy your changes back to the main table,
but this really defeats much of what Access does best, so I wouldn't
recommend it for as slight a reason as personal preference...
 
Hi MacDermott, i just want to make sure that the changes are final and is it
ready to be writen on the table. when i press the subform and under the
events i see "before insert" and "after insert" events and u think i could do
anything there. u know when tested with a msg. it would display a msg before
insert. and u think i could make that to wait until some other button is
pressed for example save button. I don't know how to. and u know when i have
to create a temp table, i have creat 24 subforms and i just want to do in a
easier way. any ideas. and thanks for the repaly.
 
The "Before Insert" event fires before a new record is created (that is,
when the first item of data is entered into the new record); the "After
Insert" event fires just after that first item of data is entered.

I don't think creating a temp table is a good option, either.
Just check your changes in each record of the subform before you move off
that record or return to the main form.
If you like, you can use the "Before Update" event of the form in the
subform control to ask the user if all of the data in that record is ready
to be saved.
That's how Access is made to work, so that's the easiest way.

BTW - it would be a lot easier to read and understand your posts if you'd
use standard English conventions like capitalization and the spelling "you".
 
Back
Top