VB2008: Add Sub Routine stopped working

[Kenkob]

I'm new to databases and cannot work out what has gone wrong with my code. It worked the first few times. Then it just suddenly stopped when clicking the Add new record button, I do not get cleared txt/dtp input boxes.

Any help in educating me by improving my code or informing me of what has gone wrong would be fully appreciated.

I have hopefully, followed the correct actions to attach form code.

I am using Windows 7 and Visual Studio 2008 Pro.

[Hack]

What code are we trying to improve?

[Kenkob]

The attached code named frmComCars.vb

[techgnome]

there isn't anything attached.

-tg

[Kenkob]

I clicked on the button Manage Attachments, Browsed to my code, and then clicked Upload. There appears to be no further action except to close the form.

OOPS! Have just spotted the paper clip above. Please accept my apologies for wasting your time but I am new to all of this. Please except my thanks in advance for your kind offer to advise and help me.

frmComCars.vb

[Kenkob]

tg,
Hoping to resolve my problem myself over the weekend, I appear to have made things a little worse.

Another subroutine I had working now appears to have stopped. This was not included in the previous download but is attached here. I've taken the liberty of attaching the complete codefrmComCars.vb.

I am a amatuer programmer (I hope) and this is my first attempt at attempting to write a small program correctly as a favour for a friend.
Code wiae, I've only ever seen code published in books, tutorials and or samples.

I would be extremely pleased to see a professional finish or your advise on what else I need to do once the program is working.

K

[Kenkob]

tg,

Have resolved my second problem.

However, I have failed to determine why the code in the first download will not permit me to Add records to the database. It performs all other functions correctly.