Editing and Updating

[GPIT]

Hello all,
I am using the following code to update a record in a table, but instead of updating the record it is adding a new record.
-------------------------------------------------
With rstMillData
rstMillData.Edit
rstMillData!ReleaseNo = vReleaseNo
rstMillData.Update
End With
-------------------------------------------------
Thanks.

 

[dyarwood]

Could you possibly use the Fields property, eg

rstMillData.Fields(0).Value =x

So the current record level under the 1st field would be given the value x.

dyarwood