The data has been changed???

[QB]

I am using a controlès after update event to perform an update on a subformès
control.

I base the subform's date on the main form's control value + 6 weeks. I
have validated the calculation is working fine but the final step, updating
the subform is failing and generating an error 'The data has been changed'???

I am simply doing what I have done 100s of times before but for some reason
this time it is spitting out an error?

Me.subform.Form.control = dtNewDate

Anyone know what I have done wrong?

 

[Armen Stein]

I am using a controlès after update event to perform an update on a subformès
control.

I base the subform's date on the main form's control value + 6 weeks. I
have validated the calculation is working fine but the final step, updating
the subform is failing and generating an error 'The data has been changed'???

I am simply doing what I have done 100s of times before but for some reason
this time it is spitting out an error?

Me.subform.Form.control = dtNewDate

Anyone know what I have done wrong?

So, is the subform bound to the same table as the main form? Your
post isn't clear on that.

If so, you'll need to save the main form record before attempting to
change the record in the subform.

If not, then maybe you can provide more information about how the two
are related. This error is typically caused when the record the form
is based on was changed "under the covers" in code before the form had
a chance to save.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com