recordsets....

[CHAOSinACT]

i'm loading a ADODB recordset and to simply extract and replace the data in afield.

i've done this in bulk with a 'With" statement but when i try to access a single value in a field it goes all wrong.i would SWEAR that a simple:

sampleVariable = rsCivilActivitySlips!TotalSpent

would work if rsCivilActivitySlips is an open ADODB Recordset and TotalSpent is a field (albeit calculated) in the (in this case) query. Am i bonkers or what?

edit: found that - seems to be other probs in there though they me be EOF issues

 

[Banana]

Are you updating the recordset as you go by? If so, did you issue .Update *before* you move to anywhere else?

 

[CHAOSinACT]

yeah i worked it out, simple syntax. on to worse problems lmao. check for my other post....