<div>
<div class="content wysiwyg-content">
I'm using Access 2003 in a project with a SQL 2005 back end. With &quot;server filter by form&quot;, when I put a checkmark in by checkbox I get a [Server Filter] value of &quot;table.column = -1&quot;, which doesn't return any data. If I change the -1 to 1 then I get data.<br />
<br />
Is there a way to make a checkmark in a checkbox work with &quot;server filter by form&quot; without me figuring out how to intercept the action and replacing all the -1's with 1's?
</div>
</div>


I'm using Access 2003 in a project with a SQL 2005 back end. With "server filter by form", when I put a checkmark in by checkbox I get a [Server Filter] value of "table.column = -1", which doesn't return any data. If I change the -1 to 1 then I get data.

Is there a way to make a checkmark in a checkbox work with "server filter by form" without me figuring out how to intercept the action and replacing all the -1's with 1's?

filter by form with checkbox against SQL-Server

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.