Error '3426' When Updating Database

[Christina Grabe via AccessMonster.com]

Here's the code:
Private db As Database, rs As Recordset

Set rs = db.OpenRecordset("Table")

rs.AddNew
'User puts in some stuff in form and hits okay
rs.Update

This stuff works perfectly for the FIRST record only. When I try to add a second one, it gives me the runtime error '3426': This action was cancelled by an associated object.
Any ideas on how to fix this?

--
Message posted via http://www.accessmonster.com

[David Schofield]

On Wed, 29 Dec 2004 18:27:15 GMT, "Christina Grabe via
AccessMonster.com" <fo***@AccessMonster.com> wrote:

Here's the code:
Private db As Database, rs As Recordset

Set rs = db.OpenRecordset("Table")

rs.AddNew
'User puts in some stuff in form and hits okay
rs.Update

This stuff works perfectly for the FIRST record only. When I try to add a second one, it gives me the runtime error '3426': This action was cancelled by an associated object.
Any ideas on how to fix this?

--
Message posted via http://www.accessmonster.com

Hi
see "PRB This Action was Cancelled by an Associated Object.(3426)"
perhaps, at
http://support.microsoft.com/kb/q189851/

or serach Google for "This Action was Cancelled by an Associated
Object" with the quotes.
"http://support.microsoft.com/kb/q189851/

David

[Christina Grabe via AccessMonster.com]

I did those things before posting this and they didn't help much. My recordset was not pointing to a null and Google didn't give me much to go on. HOWEVER, I did get my database working anyway...I just still don' t understand where the issue was in the database. Thanks, though.

--
Message posted via http://www.accessmonster.com