I am having a problem with Access 2003 creating a new record using a subform. Let's just call the database house. The main table has fields for item number (primary key), description, etc.
The related tables have a 1-to-1 relationship to the item number. It has fields like Applicable (True/False), and Quantity. I created three separate tables for each building, displayed in a subform from the main table. I want to have a record with zero quantity if I don't need the item right now.
The problem I am having is that when I add a new item to the main table, the subforms don't always save. I have the subforms default to True, and even added an autonumber field. The subforms populate with data from the main table (item number, description, etc.), but when I click the button to go to the next record, it doesn't create the record in the related table.
The only reliable way I have found to create the records is to set the Quantity value to something, click the button to go to another record, and then go back and delete the Quantity. I thought having a logical value set to true, or an autonumber value would cause the record to get created.
One additional thing. I have the navigation borders removed for my subforms, so that I can't click each one individually. But, if enter a quantity for each subform, all of them will be created. If I don't enter anything (i.e., only the logical box is checked), it doesn't create the record.
What am I doing wrong? Why won't the autonumber and logical True values cause the records to be created?
Thanks.