<div>
This does the job. &nbsp;Thanks for the insight. &nbsp;Got my mind out of the idle state. &nbsp;Was it any challenge for yours?
</div>


This does the job.  Thanks for the insight.  Got my mind out of the idle state.  Was it any challenge for yours?

<div>
I haven't used MS Access in literally about a decade. &nbsp;Had to open up Access 2010 and play with it to make sure I was right. &nbsp;;)
</div>


I haven't used MS Access in literally about a decade.  Had to open up Access 2010 and play with it to make sure I was right.  ;)

<div>
<div class="content wysiwyg-content">
I need to create a variable or control name from a string.<br />
<br />
For example, I am given a number which is 1, 2, 3, 4 or 5. &nbsp;<br />
<br />
If the number is 1, I need to reference the form control named cboWS1.<br />
If the number is 4, I need to reference the from control named cboWS4.<br />
etc.<br />
<br />
I could use the Select Case statement for this simple example, but my application utilizes a dozen variables that need to have the selected number included in their names...<br />
cboWS4<br />
cboAG4<br />
cboLT4<br />
etc.<br />
<br />
It's simple enough to concatenate the &quot;1&quot; to &quot;cboWS&quot; to create &quot;cboWS1&quot;, but how do I use this string to create a statement such as... &nbsp; &nbsp; &nbsp; Variable1 = cboWS1<br />
<br />
Something to the effect... &nbsp; &nbsp; &nbsp;Variable1 = CName(&quot;cboWS1&quot;)
</div>
</div>


I need to create a variable or control name from a string.

For example, I am given a number which is 1, 2, 3, 4 or 5.  

If the number is 1, I need to reference the form control named cboWS1.
If the number is 4, I need to reference the from control named cboWS4.
etc.

I could use the Select Case statement for this simple example, but my application utilizes a dozen variables that need to have the selected number included in their names...
cboWS4
cboAG4
cboLT4
etc.

It's simple enough to concatenate the "1" to "cboWS" to create "cboWS1", but how do I use this string to create a statement such as...       Variable1 = cboWS1

Something to the effect...      Variable1 = CName("cboWS1")

How to create a variable name from a string

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.