Unbound Subform error

C

Chris

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
 
Top