VBA Code to set a filter

[3535]

Can anyone tell me what is wrong with this line of code, I get error &quot;2448&quot;<br>
Me.Filter = &quot;Territory = &quot; '& InputBox(&quot;Get Territory:&quot;,&quot;Get Territory&quot&&quot;&quot; '<br>
<br>
<br>

 

[rochelle]

It should be:<br>
<br>
Me.Filter = &quot;Territory = &quot;&quot;&quot; & InputBox(&quot;Get Territory:&quot;,&quot;Get Territory&quot & &quot;&quot;&quot;&quot;<br>

 

[3535]

Thanks Rochelle, will try it again. Ray<br>

 

[3535]

Works fine now on Text field, one more question, how do I get this code to filter to Number field ?<br>
<br>
<br>

 

[rochelle]

Try this<br>
<br>
Me.Filter = &quot;NumericFieldName = &quot; & InputBox(&quot;Get Numeric Field:&quot;,&quot;Get Numeric&quot<br>
<br>
<br>
<br>

 

[3535]

Thanks Rochelle, once again your advise works great. Ray<br>
<br>
<br>
<br>
<br>
<br>