Runtime error 7878 Data has been changed

[jle0003]

I have a main form with a subform. The subform is disabled until an option is selected from a combobox on the main form and then, depending on the selection from that mainform combobox, some of the comboboxes on the subform autofill with data and disable. The error occurs when a user makes a selection from the mainform combobox then enters data into the subform and then goes back to the mainform and makes a change in the data. Is there any way to prevent this error? If the user makes a selection in the mainform and then moves on to the subform only to realize they entered the wrong thing in the mainform so they try to edit it, my database crashes. Any ideas?

Thanks!!

[rpeare]

Without a sample of the database or at the very least the code that runs your form/subform operations it's going to be extremely difficult to give you direction. If you want to provide a sample database (please make it 2003 for a wider audience) put some garbage data in it then zip it up and upload it we can all have a look.

[tanvi]

'Runtime error 7878 Data has been changed' error occurs when you are trying to change data in two places at the same time. It can be due to using the wrong events or using recordsets and forms to update data.