<div>
Alternatively in VBA, try something like this:<br />
<br />

<pre><code id="code-20-40080909-1">dim strSQL as string
strSQL = &quot;SELECT * FROM qryEstimateDetailReport WHERE [EstID]=&quot; &amp; Me.txtEstID&quot;

Set rs = CurrentDb.OpenRecordset(strSQL)</code></pre>
</div>


Alternatively in VBA, try something like this:



dim strSQL as string
strSQL = "SELECT * FROM qryEstimateDetailReport WHERE [EstID]=" & Me.txtEstID"

Set rs = CurrentDb.OpenRecordset(strSQL)

<div>
Am getting an error on:<br />
<br />
strSQL = &quot;SELECT * FROM qryEstimateDetailReport WHERE [EstID]=&quot; &amp;&nbsp;Me.txtEstID&quot;
</div>


Am getting an error on:

strSQL = "SELECT * FROM qryEstimateDetailReport WHERE [EstID]=" & Me.txtEstID"

<div>
Whoops - drop the last quote:<br />
<br />

<pre><code id="code-20-40080987-1">strSQL = &quot;SELECT * FROM qryEstimateDetailReport WHERE [EstID]=&quot; &amp; Me.txtEstID</code></pre>
</div>


Whoops - drop the last quote:



strSQL = "SELECT * FROM qryEstimateDetailReport WHERE [EstID]=" & Me.txtEstID

<div>
<div class="content wysiwyg-content">
I'm trying to set a recordset using the following but it is not limiting the results to the EstID<br />
<br />
Set rs = CurrentDb.OpenRecordset(&quot;q<wbr />ryEstimate<wbr />DetailRepo<wbr />rt&quot;, , &quot;[EstID]=&quot; &amp;&nbsp;Me.txtEstID)<br />
<br />
What am I doing wrong?
</div>
</div>


I'm trying to set a recordset using the following but it is not limiting the results to the EstID

Set rs = CurrentDb.OpenRecordset("qryEstimateDetailReport", , "[EstID]=" & Me.txtEstID)

What am I doing wrong?

Recordset issue

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.