need advice on duplicate entries..

[AthrenClain]

Hi guys i'm new here. Most of you might find this easy to deal with but i'm a bit lost in confusion..

So, i'm trying to update fields using .addnew + .update the thing here is that serial number(primary key) also gets included in the addition every time i run a save.. And i cant undo this duplicate functionality because this is what my teacher asked me to work with.. What i want is that the other fields which aren't primary keys get added and the serial number can be displayed as a reference.. I want to add that all fields im trying to update are added into one form.. A quick response and help will be greatly appreciated thanks guys...

 

[vbaInet]

I'm guessing you are working with DAO.

Your query is very unclear. You said you are trying to update fields but you are using AddNew. The AddNew method is for adding a new record to a table. So if you want to edit a record, you need to:

1. Move to the record by finding it
2. Edit the record using the Edit method
3. Finally, Update the record