I am trying to add a new record to an access db using vb but every time i try it goes to overwrite a record, i am using data.recordset.addnew and then data.recordset.update but this isnt working. The only way i can add a new record is by closing andthen opening the program.
Please can someone help me!
Cheers in advance
Simon