retrieve value of a field 1

[YanaD]

i need to retrive a value of a field but looping through a fields like Doc1, Doc2, doc3 and to the doc10. so i did:
for i = 1 to 10
DocValue = rs!doc & i.value
do whatever
next
I need to know if i am right or not?

 

[RickSpr]

Not quite right.
DocValue = rs("doc" & i.value)

rs!doc & i.value attempts to get the value of the "doc" field, then concatenate the value of the "i" control. In other words, the "!" operation occurs before the "&" operation. Rick Sprague

 

[MatsHulten]

Or you could do it this way:

Dim oField as ADODB.Field
Dim oRs as ADODB.Recordset

'Code...

For Each oField in oRs.Fields
DocValue = oField
'Whatever...
Next

Good Luck
-Mats Hulten