recordset field name variable

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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]
 
Aaaahhh yes, that is what it is. I couldn't remember what it was.

Thanks!

Brad

ruralguy via AccessMonster.com said:
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
 
Back
Top