Write Conflict

[livvie]

Hi
I am getting the write conflict error message because I have a form with 3 subforms on it. When I enter the details on the mainform they are saved but then I need details from the subforms to be written to the mainform and it's table. I am getting the data written using the update method but how do i stop the messages coming up. The records and updated info is being added fine.

 

[willir]

livvie

I am getting the data written using the update method but how do i stop the messages coming up.

I am going to take a stab at this. You get a message

You are about to append xxx rows

?? Are you referring to VBS code such as...

DoCmd.RunSQL Insert or Delete SQL statement?

If so, I suspect you want...

[b]DoCmd.SetWarnings (True)[/b]
DoCmd.RunSQL 
[b]DoCmd.SetWarnings (False)[/b]

Make sure to set the warning back on after your update - otherwise you will not be warned when you use the query builder for creating and testing SQL statements.

If this is not what you are looking for, would you be kind enough to supply a little more information for us to go by?

A brief description of your database / forms adds relevance.

How are the subforms connected to the main form? Are they related one-to-many as child records?

Richard