Previously entered values disappear...?

[DataMiner]

Hi,
I have a form with two interrelated controls, "InspPoint" and "DefectType". Both of these are comboboxes and bound controls. The InspPoint AfterUpdate event updates the rowsource for DefectType.

When InspPoint="Handsolder", the rowsource for DefectType is "1,2,3,4,5"

When InspPoint="Prep", the rowsource for Defect Type is "1,2,3"

That all works fine, but here's the rub:
This form will be used as a datasheet. When InspPoint for any one record changes to "Prep", all the DefectTypes 4 & 5 entered for other records disappear. They don't get deleted from the table or anything, they just blank out on the form. The next time a record gets entered with DefectType = "Handsolder", they reappear.

This seems like it would be pretty confusing to people entering data. How do I get around this?

Access 2002 on Windows XP.

 

[mohammadagul]

hi,
the same thing happened to me when i was developing a db for accounting purpose. what i simply did was delete that form and redesigned it again. i believe this is Ms Access problem. Somtime the form get corrupted . the Reason! well no specific. so i would suggest yiou to keep that form in the store and design it again.