View Single Post
  #1 (permalink)  
Old December 8th, 2011, 11:41 PM
iamerin iamerin is offline
Registered User
Points: 5, Level: 1
Points: 5, Level: 1 Points: 5, Level: 1 Points: 5, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Dec 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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


Reply With Quote