<div>
Pat you are correct thats what I ended up doing
</div>


<div>
<div class="content wysiwyg-content">
I have a drop down box on a form that you select a client then I want to push a button that garbs those records in a table and displays them for editing.<br />
The code im using is &nbsp;<br />
<br />
dim stLinkCriteria as string<br />
stLinkCriteria = &quot;[Client Name]=&quot; &amp;&nbsp;&quot;'&quot; &amp;&nbsp;Me![SingleAcctName] &amp;&nbsp;&quot;'&quot;<br />
docmd.opentable &quot;Structure&quot;, , stLinkCriteria <br />
<br />
and Im getting a type mismatch<br />
<br />
stLinkCriteria looks like this &quot;[Client Name]='Home Depot'&quot;<br />
what am i doing wrong?
</div>
</div>


I have a drop down box on a form that you select a client then I want to push a button that garbs those records in a table and displays them for editing.
The code im using is  

dim stLinkCriteria as string
stLinkCriteria = "[Client Name]=" & "'" & Me![SingleAcctName] & "'"
docmd.opentable "Structure", , stLinkCriteria 

and Im getting a type mismatch

stLinkCriteria looks like this "[Client Name]='Home Depot'"
what am i doing wrong?

I want to open a table to specific records using a drop down box on the form

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.