Index or primary key cannot contain a Null value!!!!

[yayay]

I am currently trying to insert a record into my database. The fields in my table are RecordID, BillNumber, CongresspersonID, and Vote. RecordID is the primary key and its data type is Autonumber. It says the primary key can't be null, but it's not! It wouldn't let me upload the database because it says it's too big. This is my code:



PrivateSub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.ClickcongressCommand.CommandText = "Insert into votingRecord(BillNumber, CongresspersonID, Vote) Values('" & ComboBox1.Text & "', '" & TextBox1.Text & "', '" & ComboBox2.Text & "')"
Dim numOfRecordsChanged AsInteger = congressCommand.ExecuteNonQuery()
If numOfRecordsChanged = 1 Then
MsgBox("A new voting record has been added")
Else
MsgBox("Error: Please contact administrator")
EndIf
EndSub

[June7]

Are these fields all text datatype? If not, don't use apostrophe delimiters.

Also, don't use the .Text property, .Value is what you want but since .Value is the default, don't need to even type it.

Did you run Compact & Repair and zip the db? Zip still too big, copy db and remove data (leave a few records for testing).

[yayay]

The fields are all text datatype.
Here is the attachment:
Congress1.accdb

Are these fields all text datatype? If not, don't use apostrophe delimiters.

Also, don't use the .Text property, .Value is what you want but since .Value is the default, don't need to even type it.

Did you run Compact & Repair and zip the db? Zip still too big, copy db and remove data (leave a few records for testing).

[June7]

That db has three tables - no queries, forms, or code to analyse.

[yayay]

All of my code is in Visual Studio. I'm inserting into the database from my project in Visual Studio.

That db has three tables - no queries, forms, or code to analyse.

[June7]

I have never coded behind Visual Studio. If you provide the VS file, might be able to help. Would be a learning experience for me.

Or might have better luck posting to a VS forum.