recordset field name variable

[Guest]

Thanks for taking the time to read my question.

how do I do

dim rst as Recordset ... and so on

rst!VariableValueHere

So that I can make VariableValueHere any field name I want.

Thanks,

Brad

 

[ruralguy via AccessMonster.com]

From VBA help:

To refer to a Field object in a collection by its ordinal number or by its
Name property setting, use any of the following syntax forms:

Fields(0)

Fields("name")

Fields![name]

 

[Guest]

Aaaahhh yes, that is what it is. I couldn't remember what it was.

Thanks!

Brad

From VBA help:

To refer to a Field object in a collection by its ordinal number or by its
Name property setting, use any of the following syntax forms:

Fields(0)

Fields("name")

Fields![name]

Thanks for taking the time to read my question.

how do I do

dim rst as Recordset ... and so on

rst!VariableValueHere

So that I can make VariableValueHere any field name I want.

Thanks,

Brad

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com

 

[ruralguy via AccessMonster.com]

You're welcome. Glad I could help.

Aaaahhh yes, that is what it is. I couldn't remember what it was.

Thanks!

Brad

From VBA help:

[quoted text clipped - 20 lines]