Variable addressing of fields

[Guest]

I have a table that has fields named 'item1', 'item2'...
I want to combine them together but the rst1![cntr] returns an error that
the item is not in the collection. i know that the recordset has a field
named item1 and that there is a value contained in the field of the record
being addressed.

For counter = 1 To 20
cntr = "item" & counter
rst1!item21 = (rst1!item21 & rst1![cntr])
Next

How can I address the 'rst1![cntr]' at the end of line 3 above to retrieve
the value contained in the table?

Thanks for your help!!

 

[John Spencer]

Try the following

rst1!item21 = rst1!item21 & rst1.Fields(cntr)

 

[Guest]

I still get the error message now saying that rst1.Fields(cntr) is 'item not
found in this collection' .

Try the following

rst1!item21 = rst1!item21 & rst1.Fields(cntr)

I have a table that has fields named 'item1', 'item2'...
I want to combine them together but the rst1![cntr] returns an error that
the item is not in the collection. i know that the recordset has a field
named item1 and that there is a value contained in the field of the record
being addressed.

For counter = 1 To 20
cntr = "item" & counter
rst1!item21 = (rst1!item21 & rst1![cntr])
Next

How can I address the 'rst1![cntr]' at the end of line 3 above to retrieve
the value contained in the table?

Thanks for your help!!

 

[Guest]

I needed to add an edit/update to the code. then it works!! THANKS!

Try the following

rst1!item21 = rst1!item21 & rst1.Fields(cntr)

I have a table that has fields named 'item1', 'item2'...
I want to combine them together but the rst1![cntr] returns an error that
the item is not in the collection. i know that the recordset has a field
named item1 and that there is a value contained in the field of the record
being addressed.

For counter = 1 To 20
cntr = "item" & counter
rst1!item21 = (rst1!item21 & rst1![cntr])
Next

How can I address the 'rst1![cntr]' at the end of line 3 above to retrieve
the value contained in the table?

Thanks for your help!!

 

[John Spencer]

Well, if the field exists in the recordset you should be able to reference
it using any of these methods

rst1!item20
rst1("Item20")
rst1.Fields("Item20")

Do you have fields in the recordset named Item1 to Item20?
Is the fieldname Item1, Item01, or Item 1?

Normally, when I have this type of problem, I've failed to include the field
in the recordset or misspelled the name of the field.

Beyond that I have no suggestions.

I still get the error message now saying that rst1.Fields(cntr) is 'item
not
found in this collection' .

Try the following

rst1!item21 = rst1!item21 & rst1.Fields(cntr)

I have a table that has fields named 'item1', 'item2'...
I want to combine them together but the rst1![cntr] returns an error
that
the item is not in the collection. i know that the recordset has a
field
named item1 and that there is a value contained in the field of the
record
being addressed.

For counter = 1 To 20
cntr = "item" & counter
rst1!item21 = (rst1!item21 & rst1![cntr])
Next

How can I address the 'rst1![cntr]' at the end of line 3 above to
retrieve
the value contained in the table?

Thanks for your help!!