Last field entered does not get saved

[nikky]

I have a form where you can add multiple entries .. but the last field that gets entered does not get saved unless you tab to another field after making the entry..

How can I get around this in the form ? I've tried DoCmd.Save but that does not save the last field modified/entered..

 

[WildHare]

If I understand this, you have a multi-record ("continuous") form, with the ability to enter 1+ records at a pop.

When you finish with the "last" field of the "last" record on the form, Access does not save this record when you close the form? This is a variation from what Access normally does when you close a bound form, e.g. post all record changes to the dataset.

Can you explain further about your particular situation?




Don't be sexist - Broads hate that.
Another free Access forum:

http://www.forumco.com/jmhare

More Access help stuff at

http://www.jmhare.com/wildhare.htm

 

[RoyVidar]

Docmd.Save, would only save design changes of the form. To save the record, use for instance:

[tt]docmd.runcommand accmdsaverecord[/tt]

But what you're exposed to, might also be a flaw. This link "Losing data when you close a form", recommends trying the following within the close routine:

[tt] If Me.Dirty Then
Me.Dirty = False
End If
DoCmd.Close acForm, Me.Name[/tt]

Roy-Vidar