Replace value in table with DAO

  • Thread starter Thread starter Luke
  • Start date Start date
L

Luke

I need to replace value in a table. This table has 3
fields (Old, New, Path), 1 row of values, and I need to
change values in the Path field, only.

Currently, I use the following code (strDirectory
contains the new value:
With rst
.Delete
.AddNew
!Old = "Reference"
!New = "Position "
!Path = strDirectory
.Update
End With

This code deletes and replaces the whole row. I would
like to replace just the Path leaving the rest
untouched. I use DAO.

Any suggestions?

Thank you.

Luke
 
Thank you. It works great. Exactly what I want. How on
earth did I miss this, I do not know.

Luke
 
Back
Top