Problems with "Add New" cmdbtn Unbound Form Dissconnected Recordset
In Chapter 5,page 142 "Building an Unbound Contacts Form Using a
Disconnected Record Set."
When I run this code substituting my own database,Table and Form
(using the identical code, including commented lines), it works
fine except for one thing: the "Add New" command button on the
form has a problem.
If I add just one new record using this cmd button and
immediately click on the cmd Button "Save all changes to
DataBase" everything is ok. However, when I try to click on "Add
New" two or more (say three) times to add more that one record
and then click "Save all changes to DataBase", only the last
(i.e. the most recently added) record has data saved. The Table
to which the records were saved shows two other new records that
have no data in them.
Also if I click "Add New" and then click "Go Previous" a run-time
error occurs,"Multiple-step operation generate error..."
Can someone tell me what is wrong here, and how to fix it?
(Again, the code is entered correctly. I've checked it numerous
times).
Thanks
|