Data not saving from bound form when control loses focus

[Veus]

Hello,

I noticed this thread:
http://groups.google.co.uk/group/mi...st&q=save+data+control+focus#47e8c7ca272a99b9

In this thread it says that if a form is bound (which mine is to a
query) when a user moves from control to control it should save when
the control loses focus.
It currently saves when users close or move from record to record
however this is causing problems as sometimes users use a custom
toolbar which opens up popup forms to perform other tasks, which dont
close or affect the bound form (so no data saved).

Also if a user edits a control on the bound form then clicks a button
to go to another form related to the bound form, the recently edited
value is the original (so the data isnt saving).
For the second problem I know I can input Me.Dirty commands in the
button to force refreshes, however after reading that thread that it
should auto save anyway I feel it is a problem with my database.

Obviously I would want this applied to all forms with the minimum
effort.

Can you think of any way to do this?
Also is what is mentioned in the thread above true? Should it auto
save?

Thanks

 

[Klatuu]

I believe you misread the post. A record is only saved when you move to
another existing record or add a new record or when you close the form. Your
problem may be the custom toolbar or moving to another form.

I would suggest you use the Me.Dirty to save the record when you need to.