Create new record in subform

[david.paige]

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.

[RuralGuy]

Default values and AutoNumbers do *not* dirty a record. You would need to dirty the record in the SubForm for it to save automatically. BTW, 1:1 relationships are unusual in a RDBMS.

[Grooz13]

in small db, sometimes I create "Creation Field" in wich i put automaticly à 0 in the vb code... it will records since it will contain an information

[david.paige]

Thanks for the quick reply. I'll read up on how to dirty a record,and play with a bit. Maybe I can create a script to dirty the record when it displays.

I went the 1:1 route because I have a known number of "houses." I keep the item description and serial number in the main table, and have a table for each "house." Either the house has a wetbar/fireplace/garage or it doesn't. If it does, then it's that specific model.