I have a subform that is linked to a main form in the following way:
Main form
PK quest_id - AutoNumber
Subform1
PK sheet_id - AutoNumber
FK quest_id
Subform2
PK age_id - AutoNumber
FK sheet_id
FK quest_id
I can enter information into the main form with out any problem.
After entering info into the 1st subform i try and move into the 2nd subform. Sometimes i have no problems and it functions as i expected it to. Other times when i move out of the 1st subform and into the 2nd i get #Delete in all of the fields in the 1st subform. The form freezes up and I have to close the form and reopen it. When opened again the info reappears.
Any help would be gratefully received
Main form
PK quest_id - AutoNumber
Subform1
PK sheet_id - AutoNumber
FK quest_id
Subform2
PK age_id - AutoNumber
FK sheet_id
FK quest_id
I can enter information into the main form with out any problem.
After entering info into the 1st subform i try and move into the 2nd subform. Sometimes i have no problems and it functions as i expected it to. Other times when i move out of the 1st subform and into the 2nd i get #Delete in all of the fields in the 1st subform. The form freezes up and I have to close the form and reopen it. When opened again the info reappears.
Any help would be gratefully received