I'm trying to have a form save automatically after updating values.
I have two fields that I've successfully been able to get to update the default values with the last values entered, but when the form is closed and reopened without physically saving, it reverts to the old default values.
My form has two fields and a button that runs a macro.
This is the code to update the default values of the two fields:
Option Compare Database
Private Sub Mailer_LostFocus()
Me.Mailer.DefaultValue = Chr(34) & Me.Mailer.Value & Chr(34)
Private Sub Start_LostFocus()
Me.Start.DefaultValue = Chr(35) & Me.Start.Value & Chr(35)
Then in the Macro that I'm running, at the end I use the "SaveObject" command and pick Object type "Form" and Object Name "Run Me".
Somehow though, the form is not actually saving when the command runs. Is there a VBA command I can run after each of the two above to cause the form to save?
Thanks for your help!