I have been asked to fix a problem with an Access 2000 database. It is one main table with several tables used to populate dropdown lists. However, the table had too many fields, so it was broken into two tables with a one-to-one relationship. The query joining these two tables is then used as the basis for a form that consists of 8 tabs. There are also several computed fields, (mostly sums) which I have made into data with sources of the type "=a+c+d" with a, c, and d being columns that occur in the query.
The form seems to work for altering data already there, but when I try to add a new record, I key in the key (which is then copied to the key for the other table with a vb statement), the database terminates. No error message, nothing in the event logs. It just goes away.