I have written a DB in 97 and converted to 2002. I then secured my DB in 2002. This is a multi user environment. My problem is that I have two different forms that has data disappear in them approximately once a day. Both forms have main forms with subforms based on the same table. Sometimes when we enter the data into the subform of a multiple line order, after hitting the enter key on the last field of one of the records the information just entered disappears from the record we just left. It also happens on single line item orders. However, this does not happen everytime. I cannot find a common thread to the disappearances based on part number used, the line in which the record is located that disappears. Nothing. The subform is based off of a query and I have checked to make sure that both tables have primary keys and relationships properly marked. I have also enforced referential integrity thinking this might be part of the problem. I have replaced the form with an original copy but no luck. Does anybody have any ideas. This is my first DB and it is quite complex. For the most part, the database works well except for the problem described above and an occasional corrupt record. I wanted to start with the disappearances first. Any suggestion is appreciated.
Thanks,
Rhonda
Thanks,
Rhonda
Last edited: