[RESOLVED] VB only save one records to access db

[Robban98422]

Hello.

Iam working on a little software for fun.

Right now i am at "car service maintence"

I have 3 databases connected to this project
Cars
Parts
Service


The first two works fine, i can save,remove,edit etcetc

But the last one "service" iam only able to save once, then i get an error.

Iam sorry that the interface is in Swedish. mostly..

"Data sparad" = Data saved.

And the second windows, explains itself.

As you can see i can save the first record "batteri" 50:-

But when i try to add "Olja" 500:-
ive got an error


I use the exact same code on the savebutton as the other ones wich is

Try
ServiceBindingSource1.EndEdit()
ServiceTableAdapter1.Update(ServiceDataSet1.Service)
MessageBox.Show("Data sparad")

Catch ex As Exception

MessageBox.Show("Error fix your ****")

End Try

The combobox is set to "short text" in access.

Any ideas ?