Write Conflict Issue

[GarstonMassive]

I've trawled through all the posts on this subject in these forums without really finding the right answer.

My situation is that I have a Form with a tab control, that has a subform on it (dont ask), that has a tab control on it, that has a subform on it.

The problem is that when I go to a new record on the Main form, fill in some details on the last subform, and then go back to the Main form again to enter some text, I get this horrible little error box!

I've tried Refresh and Requery but they dont work.

Anyone point me in the right direction?

 

[GarstonMassive]

....forgot to mention that if I create the new Main record, then enter some text in any one of the controls (bound) then go to the last subform, type some data and then go back to the Main form.....it works!

It doesnt work if I dont type any data into the Main form.

 

[GarstonMassive]

I fixed it by implementing a very crude fix whereby in code I'm entering text into a control on the Main form and then nulling it.

Does the trick but cant understand why it's happening.

 

[GarstonMassive]

...also by way of follow-up the numpty who developed it used:

Form.Refresh

rather than:

Me.Refresh

which I changed it too and it worked!!