Force a save after a field is updated in a continuous form?

[LostInTheTrees]

I have a continuous form with a checkbox for changing the value of a boolean. If you hit the checkbox, it changes, but because you have not moved to a different field or record, the change has not been saved yet. If you then switch to another form via a tab and then switch back, the form crashes.



I have an event that runs when the form is activated. The event does a requery. This fails because the boolean field change has still not been saved.

So, how do I force a save? I can attach a Clicked event to the checkbox and force a save at that point, but I don't know how to invoke the save. None of the obvious possibilities seem to work.

-Bob

[pbaldy]

If Me.Dirty Then Me.Dirty = False

[LostInTheTrees]

If Me.Dirty Then Me.Dirty = False

Thanks!

-Bob

[pbaldy]

Happy to help!