Need contents of variable whose name is in another variable

[WaltW]

I have a situation where I have the name of one variable in a second variable, but I want to look at and use the contents of the first variable. Example:

dim strVarName as string
strVarName = "txtData"

If txtData has information in it that I want to use, but all I have to go on is the fact that the contents of strVarName is "txtData", how do I use strVarName to get the contents of txtData?

Thanks for any help you can provide!

WaltW

 

[TrojanRabbit]

It depends on what txtData is and how you're getting to it. If txtData is a control on a form, you can use .Controls(strVarName). If it's a table field, you can use .Fields(strVarName). If it's simply a declared variable, I don't think you can get to it that way.

 

[WaltW]

Thanks for the help! In this case txtData was a text box on a form, so the .Controls(strVarName) worked perfectly. So my question is answered and I'm off and running. Thanks again!

WaltW