Updating Data in Form and SubForm

[EddieN1]

I have a Form view of a record and a corresponding subform for the same record. I want to be able to make a change on the form and use that new data to update data in the subform. I am able to update the fields, however, when I leave the record and the SQL Server tries to update the record (same record, two forms), I get an error message that the record was altered after the read event. Any suggestions as to how I can do this properly?

[June7]

Why do you have a form and subform with the same data source? Maybe you should check out the Split form introduced with Access 2007.