Update Fails (Access db)

[dunfiddlin]

So, what is the Select command and, more top the point, where is it? There are a lot of items here where you seem to take it on trust that that values will carry over from other subs. I'd be very surprised if you could get away with not creating a new Adapter at the very least.

[vbchJack]

Thanks for the quick reply.
The select statement is:
strSelect = "SELECT * FROM tblFinishes"
daFinishes = New OleDb.OleDbDataAdapter(strSelect, con)
daFinishes.Fill(dsFinishes, "tblFinishes")
MaxRowsFinishes = dsFinishes.Tables("tblFinishes").Rows.Count

Originally it was in a module but I moved it to the FormLoad event. This app currently has only one form.
I have also used: "SELECT id, finish FROM tblFinishes" with the same error resulting. 'ID' is the primary key in the Access db. MaxRowsFinishes is used in the app. It always has the correct number of rows.