Solved

filter by form with checkbox against SQL-Server

Posted on 2009-04-09
1
432 Views
Last Modified: 2013-11-28
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?
0
Comment
Question by:GordonPrince
1 Comment
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
Comment Utility
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

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now