Incorrect Update syntax

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
 
D

Douglas J. Steele

Is this an ADO recordset or a DAO one?

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