Update/Delete a Record in an Access 2010 Database using Excel VBA

Hi, I am hoping someone can help me get the right code to update a record in Access 2010. I have this code which works great for creating a new Record. However I would also like to Edit and Delete records but my efforts have so far failed and my brain is becoming gloopy. My Access Table has a Column for "Recordset_ID" so this would be the unique identifier for the record.

I've tried incorporate a statement like UPDATE Analyst_Data SET Analyst_Name='Tom Lancaster' WHERE Recordset_ID=1 but this returned an error about a missing parameter value.

The code I am using to add a record is below - any help on adjusting this to update and delete a record will be very much appreciated.

Please Login or Register  to view this content.

My brain started functioning again after a cup of tea and I managed to get it to work using this code:

Please Login or Register  to view this content.

Glad you got it sorted as an aside, it's generally not a good idea to auto-instance classes e.g

Please Login or Register  to view this content.

Should really be:

Please Login or Register  to view this content.

You're unlikely to get into any issues in the short term, but it's a good habit to get into and solves problems with more complex code. If you're interested Chip Pearson discusses it on his site.