subform shows #DELETED

[trebor3900]

I have a textbox on a Subform which is updated when a record is double clicked in another Subform. This works fine until i move the mouse over the updated subform. Then the updated entry is replaced with #Deleted. The data is still in the table that gives the subform its value.
Also another form running has the same subform and it and the updated value is shown perfectly in this one.
Anyone know why this may be happening?

 

[godofhell]

Post your database, My feeling is that the data field you have selected as the source might not be pointing to the correct field and might be getting its value from a field that has been in fact deleted.

 

[trebor3900]

Database was far too large to post. But what you said about the field being deleted made me look at a query that was designed to delete the contents of the table and populate it rather than just update it. This was the problem, now sorted. sometimes you find yourself looking all around the problem.

Thanks for your time