i am trying to do a basic update of a few fields
this works
so i have no real problem, just would like to know why i am getting the errorCode:tmp(0) = Text1(0) tmp.Update
rather than updating each of the fields, would prefer to use
where the fields and values should be able to be arrays (as with addnew, which works fine)Code:tmp.Update tmp.(0), Text1(0)
but testing either individual fields or arrays give the error 3265
"Item cannot be found in the collection corresponding to the requested name or ordinal"
i have also tried tmp.fields(0) and tmp("fieldname")
i am able to access all fields in select queries
any suggestions?




Reply With Quote