M
Mark B
I have a form that contains a subform and this subform
contains three of its own subforms (sub subforms?). The
primary key in the subform is concatenated consisting of
the primary key from the main form and an incrementing
field that counts the number of items associated with the
main form primary key. These are subsequently used to link
the sub subforms to the subform. Once the primary key in
the main form (also an autonumber) changes, the
incrementing field should reset to 1. My problem is that
I can add new records in the subform and the incrementing
field works as it should, but when I try and add new
records in the main form I get an "Index or Primary Key
Cannot Contain a Null Value" error. I've been racking my
brain for about a month now with no solution in sight. Any
takers?
contains three of its own subforms (sub subforms?). The
primary key in the subform is concatenated consisting of
the primary key from the main form and an incrementing
field that counts the number of items associated with the
main form primary key. These are subsequently used to link
the sub subforms to the subform. Once the primary key in
the main form (also an autonumber) changes, the
incrementing field should reset to 1. My problem is that
I can add new records in the subform and the incrementing
field works as it should, but when I try and add new
records in the main form I get an "Index or Primary Key
Cannot Contain a Null Value" error. I've been racking my
brain for about a month now with no solution in sight. Any
takers?