I have an unbound form containing an unbound subform.

I'm using an insert SQL statement to put the data into the table from the
subform and binding the controls using standard (controlname.coutrolsource =
Rowsource. )

After the record is saved I'm unbinding the controls and using resetControl
me and ResetControlSub SubformName.

When I try to enter a second record I can enter details into the main form
but if I click on the subform I get an error message;
" Index or primary key cannot contain a null value"

I've checked that all the controls are unbound and that the link child
fields and link master fields are blank.

Any Idea's what's going on?

Please help

Views in SQL; whats in Access?
On Screen Keyboard
"Time and Billing" database question -- access
Copy expressions with one change in each of 36 boxes
Can't find Master Link and Child Link Attributes