Problem solved
The suggestions that I found on the forums did not work for me. I simply needed to add the key index to my recordset. But I have one question and I hope you can direct me in the right direction.
I need to update the total amount every time I change the quantities. I have unitPrice field, total field which will be updated, and the total field which equals price x quantity.
Example, in my database I have record 1 with unit price =2.00, qty =3, & total =6
When I update the quantity from 3 to 5, the total should automatically be updated in the database to 10. I know that I need to create a hidden field with a value of unitPrice* ?