Incorrect Update syntax

[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

 

[Douglas J. Steele]

Is this an ADO recordset or a DAO one?

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

 

[Tim]

The DAO syntax is:

rs.Fields("Xerox Imp Charge") = Impression