MS Access - Update record without closing Form
Posted on 2011-02-22
My question seems basic but I've always let the form save changes to the current record by closing the form which is bound to a table. Now I've been asked to save the changes on a button click that does not close the form. Changes need to be saved along the way instead of waiting till the very end when the user is done with the form.
Is there an easier way than itemizing each field equal to the value on the form? I know I can execute an SQL command UPDATE table SET..... or do a DAO openrecordset SELECT then set each field.....
But there are 27 fields on my form that may have been changed.