Hi All

I've form which is linked with subform
e.g
Invoice [Parent form] and InvoiceLines [Subform]

Parent Form (Invoice) connected with SQL View
when changing any field in parent form and go to subform change something there and then If I am trying to change any field in parent form whole parent form field display #deleted with an error message someother user has change value in recordset.

This error not happen if I refresh form or close form and then make another change which is not correct way to do it.

What event should i look into to save records in both forms

Please advice and suggest.

Regards

Ayaz