I am getting the following error: Write Conflict--This record has been changed by another user since you started editing it....

I think i know why, but I am sot sure what to do about it.

I have a main form with a sub form, each is based on a stored procedure with only one table in it (not the same table) and only one parameter.

When I make a change to anythign in the subform I update the main form's "last changed date" field then when I hit save on the main form I get the error.

How do I resolve this?

I am using Access 2002 SP 3 with an .ADP not .MDB and MS SQL Server 2000.

Mitch

__________________
Mitch

This may or may not help.

I ran into the same problem last week with and MDB file. On the properties for the form, I believe under the Data tab is a record locking property. In my case I set this to lock the current record.

Hopefully that will be somewhat helpful,

Mike

Mike
EchoVue.com