Checkbox issues

  • Thread starter Thread starter MsDYJ
  • Start date Start date
M

MsDYJ

I'm making a form with multiple items, but I only want certain records to
populate it.

How would I tell access that I only want to see incomplete projects, in
other words, if the completion field associated with each project ID is not
checked, show it on this form.
 
for the recordsource of the form, create a query by clicking on the
(...)dots to the right (in property sheet, Data) and in the query builder,
add the fields you want displayed, and for completion field, set criteria to
false. Run the query to make sure it works, then save.

Your form will now include only those records not marked completed.

Damon
 
Back
Top