Auto Save command

coolcatkelso

Registered User.
Local time
Today, 05:08
Joined
Jan 5, 2009
Messages
279
Hiya

Is there a code or anything that will allow a form to be automatically saved?

On my form there is a few bits of info the user should enter before moving to the next section, but for the data to flow correctly, a save is required.. Rather than having an annoying msgbox saying please save record.. Is there a way to do an automatic save every 2 mins or sumthing?
________
Wendie 99
 
Last edited:
you could use "do command save" code in whatever form/control event is most appropriate for what you're doing.

i have the following code on a checkbox that deems a product to be obsolete or not. as it is checked or unchecked, i wanted my listbox to requery (as the listbox filters for obsolete or discontinued items) but the requery would not work unless the record was saved, and the record won't save until moved to a different record, so i use this code on the "on click" event of the checkbox to save the record when this checkbox is toggled, making the change seem 'real-time' to the user:

Code:
Private Sub chkObsolete_Click()

    DoCmd.RunCommand acCmdSelectRecord
    DoCmd.RunCommand acCmdSave
    Me.lstItems.Requery

End Sub

is this what you are looking for?
 

Users who are viewing this thread

Back
Top Bottom