Index or primary key cannot contain a null value

nawaray

Registered User.
Local time
Today, 04:58
Joined
Dec 10, 2005
Messages
17
i have this form in microsoft Access which contains the fields refno name cpr and o combo box to choose the payment and add button , refno is the primary key....

when i open the form the ref no automatically appears and when i fill in the fields and choose one of the chosses from the combo box i get this message error Index or primary key cannot contain a null value
where is the eroor exactly?

any help plz
thankx
 
Paid form table:
RefNo ----text(primary Key)
ReqNo----text
CprNo-----Number
ReqType---text

ReqService table
and the combo box that i choose from is in a subform and is in another table
Servicecode----Number(primary key)
RefNo-----text(primary key)
ReqNo-----text

there is a relation between the paid table and the reqService table ( 1 to many)
 
As I said in previous post:

Post a copy of your database.

Copy your current database and remove any current data and replace with non genuine data.

The I or someone with have a look, it could be the way that you have your forms linked that is the problem and that can't be expained with the text you posted.

It is up to you if you don't want to post it then don't.
 
i tried to paste but i couldn't how can i paste anything in the forum?
 
1. Copy you database
2. Win Zip it
3 Reply to this post and look down the bottom and you will see Manage Attachements that is where you go to attach you zipped file so that it will appear here.
 
I have had a quick look at your db but I can't understand the Language
 

Users who are viewing this thread

Back
Top Bottom