Incorrect Update syntax

  • Thread starter Thread starter David Hunt
  • Start date Start date
D

David Hunt

I've got a viable recordset and am trying to change one of
the value of the fields by update; however, I think I've
got the syntax wrong.

' [Xerox Imp Charge] is a field in the recordset
' Impression is a variable

rs![Xerox Imp Charge] = Impression
rs.Update

any help would be appreciated.

David Hunt
 
Is this an ADO recordset or a DAO one?

If DAO, you need rs.Edit before what you've got.
 
Back
Top