I am trying to loop a recordset updating all fields that contain dashes. I am getting errors referring to object property not allowed.
Code:Set rs = db.OpenRecordset("myTable", dbOpenDynaset) If Not (rs.EOF And rs.BOF) Then rs.MoveFirst Do Until rs.EOF = True If InStr(rs.Field, "-") Then rs.Edit rs.Field = Replace(rs.Field.value, "-", "") rs.Update End If Loop End If