filter by form with checkbox against SQL-Server

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?
LVL 4
GordonPrinceAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
Are you using the builtin Filter By Form stuff? If so, then no, there's no way. You can always build your own Filter By Form stuff and dynamically build the SQL necessary.
0
All Courses

From novice to tech pro — start learning today.