End If
' delete the existing record
CurrentDB.Execute (strValue)
tblTable.Update ' before add the new
strValue = ""
Case Else
MsgBox "Error updating record, Code:" & CStr(Err) & ", " & Error$,
End Select
Resume Next
' --------------------- Error handling routine ---------------------
End Function
* OLX 2.2 * ...Dream Weaver...