Autosave form record

[Demon2000]

How can I make my form autosave the record Im entering as soon as I start to type.

I need it to do this because there is a report created from within the form attached to a button that uses the information entered. At the moment the user has to click save record before the report will display the active record.

 

[Rich]

Add
DoCmd.RunCommand acCmdSaveRecord
to the code behind your button

 

[Demon2000]

Cheers for that, easy when you know how I guess.

It worked a treat

 

[kate10123]

Using DoCmd.RunCommand acCmdSaveRecord
is it possible to put a period on this? so that if the user is editing a record for say 30 mins, every 15 mins the command runs.

Sometimes lots of data is entered and gets lost when the database crashes so I would like an autosave function so at least not all of the data is lost.