This is very wierd. I hope someone can give me a clue to follow...

I have an application with several tables, two of which are linked with a 3 character code in a 1->M relationship. When viewing a record, I allow users to select the related record from a modal form:
DO FORM Search WITH "Work Area" TO mbhToRecord
This form does a SELECT into a CURSOR for selection of existing records. This in turn is linked to another modal form to allow editing of the related records:
DO FORM AddWork WITH Search_Me.SelCode TO MBHToRecord

When each of these forms is closed, they return the SelCode of the selected record to the calling form:

IF !EMPTY(mbhToRecord)
REPLACE WA_Emps.WA_Code WITH mbhToRecord
=SEEK(MBHToRecord,"WorkType","WA_Code")
ENDIF

Now, it appears that occasionally, this code wipes out the contents of the WA_Emps.WA_Code filed of ALL records in WA_Emps - not just the current record. I cannot imagine how this code could possibly do that! Does anyone have any ideas?

TIA