Write Error

[mmitchell]

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.

 

[GaryPanic]

before you get to the subform -on the on click properties of the button- put a save in it and see if this helps , and aslo on the after update on the"last changed etc

test it see if it works (I had the same problem and putting insome Saves seems to have cut this down)