By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,107 Members | 1,284 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,107 IT Pros & Developers. It's quick & easy.

filter form by checkbox

P: 4
ok I have a table that contains a yes/no column (completed). I have also created a form to display records from this table which has a check box for teh (completed) column. What i want is for the form to only show record with the check box unchecked. I only want to see the uncompleted records.
Jan 11 '08 #1
Share this Question
Share on Google+
1 Reply


P: 45
ok I have a table that contains a yes/no column (completed). I have also created a form to display records from this table which has a check box for teh (completed) column. What i want is for the form to only show record with the check box unchecked. I only want to see the uncompleted records.
If you want to apply and remove this filter easily - add a filter to the form properties like "[Checkbox] is null"

Or if this is something that will always be Create a query that filters the table to only where Checkbox is null. Then change the RecordSource property of the form to the name of the query instead of the table name.
Jan 12 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.