can anyone tell me why this wont work please

DatPrice.RecordSource = "update mvpr set a2 = scost where subkey1 = Spart"
DatPrice.Refresh

What error message are you getting?

Without your being a bit more specific with what the fields are above I would guess this

Update mvpr
Set a2 = '" & scost & "'
Where subkey1 = '" & Spart & "';

This is assuming that 'scost' and 'Spart' are strings. In the future please tell us the data types that you are dealing with and I assure you that you will get me specific answers.

Kenny Alligood