How to link main form with Sub Form

[mdavid]

OK, enjoy yourself.


I'll battle on, waiting for your help.

Any ideas about "Index or primary key cannot contain a Null value" on a read only form/subform, as far as I can see the null value is in the Link Child Fields.

Thanks
David

[mdavid]

Hi all, After struggling with this for the last week I found the solution - created a new form added a couple of subforms ,within half an hour everything was working as I wanted no flashing blue circles, no error messages. I just used this tutorial as a guide. Moral of the story - if it's broken get a new one!

Thanks for all your help
David

[pbaldy]

Glad you got it sorted out. I'm busy playing with my granddaughter.

[mdavid]

Have a great time, that's what life's all about.