New to Acess Help: Index or primary key cannot contain a null value.

[Stulgs]

Hello!
I'm a new Access user and I've run into this problem with my simple two operation database.

I'm trying to record a payment, but I keep getting this error upon completion of my form:

Index or primary key cannot contain a null value.

I've checked the data types and relationships and they seem to be fine.

I've searched the forum for similar discussions, but the databases used in the solutions were much more complicated than what I'm dealing with.

Here are links to my Access files (2007 & 2003)for your reference (& help!):
http://dl.dropbox.com/u/25775187/Stu...ring2012.accdb


http://dl.dropbox.com/u/25775187/Stu...g2012%20ov.mdb

Thanks for your help!

[recyan]

Do not know if this is the cause, but till someone comes along, just check out :
Your table tblClients-Payments has Client ID as part of primary key.
Does your sub-form sfrmPayments pass the Client ID ?

Thanks

[Bob Fitz]

Have made a couple of changes to your db.

Added Client ID to the query that is the Record Source for sfrmPayments.
Entered one line of code in the form's Before Update event.
Me.[Client ID] = Parent.sfrmClient.Form.[Client ID]

This seems to give the desired result. Others may be able to offer something better.