p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   BOOK: Beginning Access 2007 VBA ISBN: 978-0-470-04684-5 (http://p2p.wrox.com/book-beginning-access-2007-vba-isbn-978-0-470-04684-5-323/)
-   -   Problems with "Add New" cmdbtn Unbound Form Dissconnected Recordset (http://p2p.wrox.com/book-beginning-access-2007-vba-isbn-978-0-470-04684-5/85970-problems-add-new-cmdbtn-unbound-form-dissconnected-recordset.html)

iamerin December 8th, 2011 11:41 PM

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



alva114 October 15th, 2015 03:30 AM


All times are GMT -4. The time now is 05:34 PM.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
2013 John Wiley & Sons, Inc.