Index or primary key cannot contain a null value

[nawaray]

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

 

[ansentry]

Post a copy of your database.

 

[nawaray]

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)

 

[nawaray]

can i have some ones help please?

 

[ansentry]

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.

 

[nawaray]

i tried to paste but i couldn't how can i paste anything in the forum?

 

[ansentry]

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.

 

[nawaray]

hi
i have attached my database

 

[ansentry]

I have had a quick look at your db but I can't understand the Language