<div>
Hi,<br />
<br />
pls try<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-41870068-1"><span>Me.QryNonSMMTData_subform.Form.Filter = &quot;CC &gt;=Me.CC.Value - 5 and CC &lt;=Me.CC.Value + 5&quot; </span>
</code></pre>
Regards
</div>


<div>
<div class="content wysiwyg-content">
I am in vba and I am trying to get access to filter 5 either side of the cc so if subform value is 2400 the filter will allow 2395 to 2405<br />
<br />
I thought this would do it<br />
<br />
Me.QryNonSMMTData_subform.<wbr />Form.Filte<wbr />r = &quot;CC= &gt;=Me.CC.Value - 5 and &lt;= Me.CC.Value + 5&quot;
</div>
</div>


I am in vba and I am trying to get access to filter 5 either side of the cc so if subform value is 2400 the filter will allow 2395 to 2405

I thought this would do it

Me.QryNonSMMTData_subform.Form.Filter = "CC= >=Me.CC.Value - 5 and <= Me.CC.Value + 5"

variance in access filter

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

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.