<div>
Try this:<br />
<br />
strsql = &quot;SELECT tblenviroment.Enviroment, tblenviroment.[&quot; &amp;&nbsp;strsql &amp;&nbsp;&quot;]&quot; &amp;&nbsp;&quot; FROM tblenviroment WHERE (tblenviroment.[&quot; &amp;&nbsp;strsql &amp;&nbsp;&quot;]&quot; &amp;&nbsp;&quot;<br />
Is Not Null);&quot;<br />

</div>


Try this:

strsql = "SELECT tblenviroment.Enviroment, tblenviroment.[" & strsql & "]" & " FROM tblenviroment WHERE (tblenviroment.[" & strsql & "]" & "
Is Not Null);"


<div>
<div class="content wysiwyg-content">
I want to pass in a variable to replace the field name of a table. &nbsp;I need the correct syntax. &nbsp;i.e.<br />
<br />
Dim strsql As String, strdte As String<br />
strdte = &quot;9/24&quot;<br />
strsql = &quot;SELECT tblenviroment.Enviroment, tblenviroment.(strsql) FROM tblenviroment WHERE (((tblenviroment.(strsql))<wbr /> Is Not Null));&quot;<br />
Me.RecordSource = strsql<br />
<br />
<br />
I need help with the - - tblenviroment.(strsql) syntax. &nbsp;<br />
I tried tblenviroment. &amp;&nbsp;[strsql] &amp;&nbsp;- - among others with no luck.<br />

</div>
</div>


I want to pass in a variable to replace the field name of a table.  I need the correct syntax.  i.e.

Dim strsql As String, strdte As String
strdte = "9/24"
strsql = "SELECT tblenviroment.Enviroment, tblenviroment.(strsql) FROM tblenviroment WHERE (((tblenviroment.(strsql)) Is Not Null));"
Me.RecordSource = strsql


I need help with the - - tblenviroment.(strsql) syntax.  
I tried tblenviroment. & [strsql] & - - among others with no luck.


Passing varaible into SQL statement

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.