Originally Posted by
RonL
There's an additional problem in that a new record appears in datasheet view before the current one is completely filled out. The new record has the (incorrect) entry for myNumber already there, even though I haven't tabbed to it yet. Even if the first problem were not occurring, it would still be incorrect (I presume), since the current record hasn't been entered in the table yet. (The data are transferred to the table from the form when you move to a new record, right?)
The 'datasheet' you're referring to, in a Split Form, is simply a display device. It is only reflecting what is being displayed in the non-split portion of the Form, it does not necessarily reflect a Record that has been saved, as yet.
And, yes, the data is normally saved when moving to a New/Other Record, closing the Form or closing Access itself.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007