I have an Access Database that I imported into VB 2005.
I have created forms and linked to the tables.
I have added a binding navigator to the form

I can move around in the records, I can modify and save records, I can delete records. What I CANT DO is add new records. When I hit the add new button in the navigator the forms moves to the next location as indicated by the record counter in the navigator.

I can enter data and everything seems to be working just great.
When I leave the form and come back, the new record that I added is not there. Only the previous count of records shows in the navigator.

I have tried everything I know and cannot seem to figure out just how to make the form save the new record.

Please point me in the right direction!

Thanks,
George Race

Without seeing the code I can only guess, but it may be that your Table/Data Adapter is not properly configured for issuing an update back to the underlying database. Is this sample code from a book or your own? In either case, is there a save function after adding a new record? Check your Table/Data Adapter's Update command to start with.



Best Regards,
Earl Francis

Hi Earl:

The tables I am using are of my own design. I have a successful program in Access VBA that I want to convert to VB2005.

I have even gone as far as to write my own new item and save language, to be used by the binding navigator "click" methods. I have imbedded message boxes in the routines so I know they are being run when I click on an icon in the binding navigator.

I think their must be some very simple thing that I am overlooking with the table setup or somewhere in that are.

I have looked at the table adaptor update command, and it appears to be configured correctly.

Seems strange that I can delete a record, modify and save a record, but just cant add a new record.

Any ideas you can suggest would be appreciated. At the moment, this seemingly simple process is holding up the whole process!

Thanks,
George

I finally have it working!

Don't know exactly what was wrong. I redid all my my SQL statements in the query group and now they all work properly.

Wish I had an answer as to what I did, but anyhow they now work.

Thanks for the help. Sure I will be back with more questions.

George